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

[@_Lalunal_]

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

[@ShimInsights1814]

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

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

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

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

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

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

[@bolaowoade]

Simple and brilliant. Thanks Jon

[@rahadislam8389]

Jon You are a just wonderful guy as a mentor

[@saitamama2927]

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

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

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

[@ibrahim-maalim]

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

[@denisemason8987]

Bless you! You are a lifesaver.

[@xx-fd4zo]

you're a blessing

[@kikiwikii]

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

[@ExcelCampus]

Awesome! Thank you so much Kiki! :-)

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

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

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

[@OzduSoleilDATA]

Power Query and Unpivot are amazing! Good video.

[@ExcelCampus]

+Oz du Soleil Thanks Oz!

[@justinlow6167]

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

[@waltonvira3008]

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

[@christelledomercq7582]

Nice tip!

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

[@mghoussoub]

Very user-friendly, excellent.

[@Mr.Sareach]

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

[@reef_brothers]

Thanks for a great informative video! This helped ALOT!

[@niyilivesinLondon-bm6ds]

Great teaching thanks for sharing the knowledge great tips!

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

[@lui6210]

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

[@jayesoteric9106]

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

[@ayasshaheen1918]

Super 👍

[@findthetruth3021]

Such amazing video wow

[@tradepbskarachi7202]

Great Sir

[@Madimetjakk]

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

[@hitmes]

Thanks

[@windycitytwins]

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

[@simonasidabriene6752]

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

[@stevennye5075]

useful!

[@Tanya-og7no]

How to get excel 2016?Help.

[@rid7073]

👎

[@rid7073]

To hard