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

Sign up for our Excel webinar, times added weekly: www.excelcampu...
Checkout the full article and download the file at: www.excelcampus...
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.
Please subscribe to my free email newsletter to get more Excel tips and tutorials like this. www.excelcampus...
PART 2: • How to Analyze Survey ...
PART 3: • How to Analyze Survey ...

[@obwanisback6653]

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.

[@jayesoteric9106]

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

[@saitamama2927]

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

[@justinlow6167]

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

[@footpatrol0]

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.

[@yolandaluan1736]

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.

[@_Lalunal_]

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

[@garrettflint1348]

Thanks for the great video! I am trying to analyze the results from a staff survey that had around 100 questions, all with multiple choice responses. Do you have any guidance for working with that number of questions?

[@redhaal-obaidy2217]

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

[@ShimInsights1814]

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

[@bolaowoade]

Simple and brilliant. Thanks Jon

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

[@ExcelCampus]

Thank you Lainie! ;-)

[@windycitytwins]

Love watching Power Query to learn stuff, but Mac needs the ability to use Power Query editor like Windows.

[@morrisw.kansuah4580]

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

[@mi98joni]

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

[@lui6210]

Thank you very much. How can we do this in Google sheets please?

[@xx-fd4zo]

you're a blessing

[@simonasidabriene6752]

Hello, I don't understand english very well. So, I dont understood how to get Sheet - Responses comma. Please help, thank you :)

[@onsys]

Thanks for a great informative video! This helped ALOT!

[@rahadislam8389]

Jon You are a just wonderful guy as a mentor

[@waltonvira3008]

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

[@christelledomercq7582]

Nice tip!

[@OzduSoleilDATA]

Power Query and Unpivot are amazing! Good video.

[@ExcelCampus]

+Oz du Soleil Thanks Oz!

[@ayasshaheen1918]

Super 👍

[@Madimetjakk]

how do i get full video from data entering to data analysis ?

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

[@hitmes]

Thanks

[@kikiwikii]

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

[@ExcelCampus]

Awesome! Thank you so much Kiki! :-)

[@mghoussoub]

Very user-friendly, excellent.

[@Mr.Sareach]

Yes, you say right. for i thing is very excellent for to work

[@niyilivesinLondon-bm6ds]

Great teaching thanks for sharing the knowledge great tips!

[@Tanya-og7no]

How to get excel 2016?Help.

[@ibrahim-maalim]

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

[@kimberly3543]

Jon, love all your tutorial videos, your explanation is clear and easy to follow. I would love to see you create more tutorials on Access or SQL as I am learning those programs. Would it be possible?

[@findthetruth3021]

Such amazing video wow

[@anthonyhrrsn102]

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.

[@ExcelCampus]

+Anthony Harrison Awesome! Thanks Anthony! I'm glad to hear it helped. Have a good one! :-)

[@rid7073]

👎

[@rid7073]

To hard

[@tristanquintus3200]

Great/useful features I may use in the future - thanks for the video.

[@tristanquintus3200]

Tried it and it works nicely. I had to download the add-in for the 2010 version, first, from MS website but after the install I now have my "Power Query" tab. Thanks again...

[@damaster720]

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

[@ExcelCampus]

+Maulanna Maryunani Thanks Maulanna! You made my day :-)

[@tradepbskarachi7202]

Great Sir

[@stevennye5075]

useful!