How to Analyze Survey Data Part 2 - Unpivot Column of Comma Separated Values

[@esthersuh3388]

Mr. Jon, you never fail me. Even I watch so many different unpivot videos, yours makes the best sense why we perform "UNPIVOT" through power query. Thank you trillions!

[@ExcelCampus]

Thanks for your feedback, Esther! 😀

[@windycitytwins]

That separate column feature is very intuitive!

[@LinaEryaniSY]

This is great, but the data is so simple, can you do a video showing how this process is done on survey data results that use Likert scale

[@77kolon]

Jon, you made Excel sooooooo easy! Thanks

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

[@edwardnewbins]

Needed this and it's still relevant! Thanks!

[@_Lalunal_]

thankssss! you explain perfectly the materials. :)

[@jennaherr9295]

Exactly what I was looking for! Very cool.

[@jeremyoakes1]

Perfect! Now, if only MS Forms would integrate this into their Excel exports! lol

[@excelisfun]

Great video!

[@bolaowoade]

Another brilliant video, thanks.

[@juliayeo812]

Hi Jon, thank you for this great and simple video and definitely has helped me in analysing the data! However under the Part 1 video, you have sorted the data with a comma and I can't seems to find the video to work on that! :( Hence looking at Part 2, you have started to split columns. ;) Please let me know which video show guidance on having the query in e.g. coffee, tea, water.. :) Cheers!!

[@Nemcsatorna123]

And what is a good practice to handle a survey with several questions? Will it be a separate sheet and separate pivot table for every question?

[@HapaxLegomenon12]

This is a good start, but what about when I have a survey with more than one multiple choice - multiple answer question?

[@gnorpflorbsen8665]

Does this automatically update when data is added to the original table or do you do this every time?

[@findthetruth3021]

Great video. Thanks

[@daxedd]

God bless you, you've saved me!

[@stevennye5075]

Excellent!

[@sarahc.167]

Thank you so much for this! Excellent explanation, really appreciate it :-)

[@MeenoZen]

This is exactly what I need. Unfortunately, it doesn't work on Mac.

[@nikitaa4469]

How to do this with multiple questions of multichoice in one survey dataset

[@CopParam25]

How can we use this for multiple columns with such comma separated values, I have a countries and business unit column for a single record, trying to get the pivot summary for such data, can you help

[@amlinroche5003]

Really Good. Thanks:)

[@asmitaaryan]

Wow..really enjoyed the way you have explained all this..I am just a beginner at Excel but would love to be a pro at both excel and SPSS soon..help me out!!

[@tristanquintus3200]

Very good, thanks...

[@monicaduman8677]

I could not follow the steps on macbook as could not find Data-from table

[@yangjungwon526]

how can i create a dashboard with 2 raw data?

[@angelperdomo5]

Oh heelll yeaaah! -Stone Cold Steve Austin