How to analyze comma-separated multiple choice survey data in Pivot Table

You have collected your data via a survey platform like Google Forms. Great job done!
How do you analyze the multiple choice part using Pivot Tables?
BONUS: Learn how to divide the count of the responses by the Number of Respondents for that question inside a pivot table.
Check out these videos on multiple response survey data
1. How to Analyze Space-separated Multiple response Survey Data in Excel Pivot Table:
• How to Analyze Space-s...
2. How to Analyze 1/0 coded Multiple Response Survey Data in Excel Pivot Table:
• How to Analyze 1/0 cod...
3. How to Analyze Columns-separated Multiple Response Survey Data in Excel Pivot Table:
• How to Analyze Columns...
SUBSCRIBE NOW and stay up-to-date in this series and more

[@MSurveyPoint]

Connect with me if you need support on the following services Email: [e-mail] Book appointment here 👉 calendar.app.google/MMasAbZPDuwCCux76 1. Survey questionnaire design 2. Online survey scripting 3. Survey data Analysis 4. Research report writing 5. Data analysis in Excel 6. Survey Dashboard in Excel 7. Survey Dashboard in Power Bi The scope of my services includes but not limited to the areas of Market Research, Customer Experience Research, Product Research, User Experience Research, Employee Engagement Surveys, NPS, CSAT & Voice of the customer, Monitoring & Evaluation, etc.

[@ahmedabdulahimahamud3272]

Perfect explanation to multiple response questions. You can't imagine how it helped me Thank you so much

[@faithngoya3883]

Oh my God, you are soooo good. This is a life saver! Thank you!

[@MSurveyPoint]

Glad this helps, Faith.

[@proudkhan82]

Thank you very much. You are very concise and clear. It helped me alot.

[@TheSakura809]

LIFESAVER!!! can't express how helpful this was :D

[@tinah426]

Thank you so much for the great work done!

[@MSurveyPoint]

Hi Tinah Happy to hear this helped. Subscribe to stay updated

[@MSurveyPoint]

Here is the sample data I used in all the videos on multiple response survey data analysis. docs.google.com/spreadsheets/d/1JC1NdgHubItR0vOKEP8mFiORdbNfILvu/edit?usp=sharing&ouid=117355798969062583983&rtpof=true&sd=true Check out these videos on multiple response survey data 1. How to Analyze Space-separated Multiple response Survey Data in Excel Pivot Table: kzbin.info/www/bejne/gHvNfmWDpbxjotk 2. How to Analyze Columns-separated Multiple Response Survey Data in Excel Pivot Table: kzbin.info/www/bejne/i57En2WHadGUeKc 3. How to Analyze 1/0 coded Multiple Response Survey Data in Excel Pivot Table: kzbin.info/www/bejne/oZXIhWeFZZaho7c 4. How to Analyze TRUE/FALSE coded Multiple Response Survey Data in Excel Pivot Table kzbin.info/www/bejne/roa8Y6WAmcmHaac 5. How to Analyze Yes/No coded Multiple Response Survey Data in Excel Pivot Table kzbin.info/www/bejne/lZbCg4tqmpeMa9k

[@annsherenova7792]

Great video. It helped me a lot. Thank you!

[@MSurveyPoint]

Hi Ann. Thanks for the feedback. Glade to hear this helps. If you have topics on survey data analysis you will like me to cover in my subsequent videos feel free to share.

[@tanyawilliamson1352]

Thank you - this helped me today!🙌

[@MSurveyPoint]

We are glad this helps. Keep supporting us.

[@andrewtirtawijaya5627]

Bro, thanks for the video. But can you help me how if i have not only one question with multiple answer but 3 question that have multiple answer. Can you advise me what is the best way to sort the data so i can use pivot table correctly?

[@MSurveyPoint]

@@andrewtirtawijaya5627 Check this video From 3 minutes on kzbin.info/www/bejne/jYmYmX-Fm6hkiJIsi=mYS4jfkmDtUL3NKb

[@MSurveyPoint]

@@andrewtirtawijaya5627 Another option is to Unpivot each of them in the same table as I have done here for comma separated. But be careful as with this option for large sample sizes and with many columns as I have mentioned in the video

[@MSurveyPoint]

@@andrewtirtawijaya5627 If you still support, you can send me an email [e-mail] Note that a small consultation fee is applied for an hour session. All the best

[@chusan5119]

Thank you.

[@kimhare7823]

Amazing video, thank you!!

[@MSurveyPoint]

Glad you liked it!

[@statistikochspss-hjalpen8335]

Hello! I'm trying to do this in reverse. I have an unpivoted table and I want to take those unpivoted rows and turn them into own columns. I have 200 unique categories meaning 200 new columns will be created. I'm not sure if I'm doing it correctly. I select the column I want to pivot. Then I go to pivot column and select survey ID and under advanced I select Count All. It generates 200 new columns as expected with 1/0. The survey IDs are not pivoted however. If a surveyID occurs multiple times it still is shown in rows as many times as it occurs. Even if it occurs 5 times I only want one row per survey id. The pivoted columns should account for the values that were present prior to pivoting.

[@ShameraIrshad]

there is no distinct count in my excel. is there any other name than that?

[@MSurveyPoint]

Hi Shamera, Probably you didn't add your data to the Data model. When you closed and load from Power query, and in the dialog box that come the "add data to the data model ✅" needs to be selected (if not automatically selected) for the distinct count feature to enabled. Please check that.

[@MarchRoses3]

How u select the three columns together in 7:00 pleasssseeeee tell me how 😭😭😭😭😭😭😭😭😭😭😭

[@MSurveyPoint]

Hi Zainab Hold down Ctrl key and click on the column headers Alternatively, select first column (preferably from the left), hold down the shift key, scroll to the right and select the last column. I hope this helps

[@MarchRoses3]

@@MSurveyPoint OMG, It’s working, thanks a lot

[@MSurveyPoint]

@@MarchRoses3 Glade this helped. Feel free to check out other videos on multiple responses and Likert scale survey data. Kindly subscribe to support me

[@زينبالبدي]

7:36 The id column doesn’t change and it is creating a problem with counting in 10:03 Places help

[@MSurveyPoint]

Check if the IDs in your data before unpivoting are unique to each respondent. Also ensure you check "Add this to the data model"

[@godfredamoako9177]

Please, I can't add to the data model. How do I go about it

[@MSurveyPoint]

Hi Godfred From 8:10 onwards Can you check if you selected "Close and Load to data model" from the Power Query Editor? Check also if the "add to model was checked" in the add to data model dialog box.

[@godfredamoako9177]

@@MSurveyPoint Yhyh...I did but it doesnt allow me to check the add this data to data model

[@MSurveyPoint]

The ✅ is enabled depending on the option you select at the top; pivot chart, connection only, etc. It will be automatically selected and grey out for some options. Can you check that. Also, are you able to proceed to generate a pivot table or chart and do your analysis? Lastly, you may consider starting over and following steps in the video closely

[@MSurveyPoint]

Cross-tabulation of multiple response survey data in Excel Pivot Tables kzbin.info/www/bejne/jYmYmX-Fm6hkiJI

[@ahmedabdulahimahamud3272]

Can you please submit other multiple response platforms Such Data from kobo please

[@MSurveyPoint]

Definitely. Coming up in subsequent videos in this series.

[@abdul-wahabinusah3340]

This is helpful to me. Can you please add how to handle multiple responses in separate columns?

[@MSurveyPoint]

​@@abdul-wahabinusah3340 Check this out. The coded versions(1/0, Yes/No and True/False) come up next. kzbin.info/www/bejne/i57En2WHadGUeKc&lc=UgzQD5gGvQ428Ix1c3B4AaABAg

[@ubaidillahmuhammad20]

nice job. but please give the files

[@MSurveyPoint]

I am happy you find this helpful. Check out my first comment I pinned on top for the data I used in all the videos on multiple response

[@ubaidillahmuhammad20]

Where is it....please put it

[@MSurveyPoint]

@@ubaidillahmuhammad20 Here is the sample data I used in all the videos on multiple response survey data analysis. docs.google.com/spreadsheets/d/1JC1NdgHubItR0vOKEP8mFiORdbNfILvu/edit?usp=sharing&ouid=117355798969062583983&rtpof=true&sd=true

[@MSurveyPoint]

You can download