Clean survey data with Excel's Power Query

Survey data poses many issues:
- Header names are not conducive to analysis tables or charts
- Multi-select columns are impossible to analyse in a Pivot Table
Excel & Power BI have Power Query which can do many of these things for you including splitting comma-separated lists into rows or unpivoting columns that are based on multi-select options, plus also learn how to rename all column names in one go.

[@pcoladawg]

This video has been such a help to me these past few weeks. It was an exact fit to what I was doing (taking responses from a survey). Thank you!

[@learnspreadsheets]

Awwww nice! So glad you’ve found it useful 😃

[@ryangomez8544]

me too!@@learnspreadsheets

[@hassanashehu7534]

Thank you very much. By watching this video I was able to do my analysis perfectly.

[@learnspreadsheets]

Fantastic! So glad to hear, don’t be shy to share with others!

[@roy-arnehgestl3615]

Great video

[@kolyuminevski73]

Great video with lots of tips and good practices.
However, I would use the ID column as unique identifier 😉

[@learnspreadsheets]

Glad you like it, yeah that could stop issues, it’s natural to database people but not where excel people would think to go!

[@broonzy2006]

Awesome vid. Thanks. Although The surveys I have are about 40 plus questions and about a third would be multi-select. Would you still separate all these out?

[@learnspreadsheets]

Good question, I would extract each but then stack the tables on top of eachother so there is only one table for single selects and one for multi selects, but the DAX does get more complicated

[@aoianalytics]

I’m survey data, should duplicates be removed? Thanks

[@learnspreadsheets]

Good question. It depends, usually yes but sometimes no

[@ExcelVisual]

Excellent

[@learnspreadsheets]

Aw fanks!!