How to Analyze Survey Data Part 1 - Unpivot Data with Power Query

Learn how to use Power Query to transform multiple choice survey data in Excel. This survey data has been exported to Excel in a format that is not easy to use for a pivot table. In this video you will learn how to use the Unpivot feature in Power Query to transform or normalize the data. This will make it easier to analyze with a pivot table and chart.

[_Lalunal_]

amaziiiing! you are really helping me with my survey and university exam!

[ShimInsights]

Thank you so much dear Jon for your palatable technical lecture!

[footpatrol]

Great! Thank you so SOOO much! Been searching for a step-by-step guide to this all over the net. This has been more useful than a semester of research methods.

[redhaal-obaidy]

Hello Jon
I would like to thank you for this marvelous video, it made my life easier and helped me a lot with analyzing the data - I've watched the 3 parts, it does the exact purpose that I was looking for.
Thanks again

[obwanisback]

Thank you for sharing this. I have a mixture of the 2. Multiple Columns with comma separated entries. Until now this has meant a lot of manual prep . This will save me so much time.

[damaster]

I always love how nicely paced your tutorials are, Jon. Not too fast, not too slow for me. Great job again on this one.

[saitamama]

Thank you so much for this, I was stuck all day with it, it helped me a lot

[rahadislam]

Jon You are a just wonderful guy as a mentor

[MrBholudas]

Thank you very much sir to provide this video. I am delighted to see your all videos. I am an operator and your all videos are very useful for me. thank you again

[morrisw.kansuah]

Note, I am so grateful to have come across this video, thanks a lot.

[justinlow]

Hey Jon.
a heads up that these three videos are in reverse order in the playlist "Excel Pivot Tables"

[anthonyhrrsn]

Awesome pointers, Jon! Especially so were those instructions for reformatting data using Power Query across MS versions from 2007 to 2016. Lots of information, use of conditioning to build anticipation for the steps without overwhelming experienced users was expertly done. Additionally, converting data from either comma-delineated or multiple-column formats and Unpivot proved extremely helpful.

[mijoni]

Thanks Jon. Encountered a challenge by a collegue this week. This solved it! Great channel btw!

[kikiwikii]

This guys is FANTASTIC. Super helpful. Super clear. Much Thanks.

[ibrahim-maalim]

This is one of the most important videos I ever watched concerning excel. All john excel campus videos too

[lainiebfranklin]

Amazing teaching skills. Love this! I have subscribed and will definitely be watching more videos as I learn to more about pivot tables and pivot charts.

[jayesoteric]

Okay i downloaded the results in raw form, Now what to do when trying to do frequency test and other tests ?

[waltonvira]

Thanks for the nice clear illustration.. can you also show how to analyse this data with power pivot??

[OzduSoleilDATA]

Power Query and Unpivot are amazing! Good video.

[yolandaluan]

Hi Jon, many thanks for the video. It's super helpful. I just have a quick question. What if the survey has, say, 10 questions and all the 10 questions' responses sit in one big spreadsheet with the 10 questions sitting next to each other in a similar layout as yours. Is there an easy to unpivot 10 questions in one go? Or it has to be separate the questions into different tabs and unpivot them one by one? With many thanks.