Clean survey data with Excel's Power Query

[@data.staplz]

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

[@learnspreadsheets]

Good question. It depends, usually yes but sometimes no

[@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

[@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

[@roy-arnehgestl3615]

Great video

[@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!

[@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!

[@ExcelVisual]

Excellent

[@learnspreadsheets]

Aw fanks!!