How to analyze comma-separated multiple choice survey data in Pivot Table
Вставка
- Опубліковано 12 лис 2022
- 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
![How to Link [Automate] Data from KoBoToolbox to Excel](/img/n.gif)
Connect with me if you need support on the following services
Email: msurveypoint@gmail.com
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.
Perfect explanation to multiple response questions. You can't imagine how it helped me Thank you so much
LIFESAVER!!! can't express how helpful this was :D
Thank you very much. You are very concise and clear. It helped me alot.
Thank you so much for the great work done!
Hi Tinah
Happy to hear this helped.
Subscribe to stay updated
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.
Oh my God, you are soooo good. This is a life saver! Thank you!
Glad this helps, Faith.
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:
ua-cam.com/video/JJjM2MpW0lw/v-deo.html
2. How to Analyze Columns-separated Multiple Response Survey Data in Excel Pivot Table:
ua-cam.com/video/Uman2Q4laBE/v-deo.html
3. How to Analyze 1/0 coded Multiple Response Survey Data in Excel Pivot Table:
ua-cam.com/video/kdeT4O01nmU/v-deo.html
4. How to Analyze TRUE/FALSE coded Multiple Response Survey Data in Excel Pivot Table
ua-cam.com/video/xUY2rJddT3E/v-deo.html
5. How to Analyze Yes/No coded Multiple Response Survey Data in Excel Pivot Table
ua-cam.com/video/_e_RX4e2Y5w/v-deo.html
Great video. It helped me a lot. Thank you!
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.
Thank you - this helped me today!🙌
We are glad this helps.
Keep supporting us.
Thank you.
Amazing video, thank you!!
Glad you liked it!
Cross-tabulation of multiple response survey data in Excel Pivot Tables
ua-cam.com/video/WX5hLOfC1R0/v-deo.html
there is no distinct count in my excel. is there any other name than that?
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.
7:36
The id column doesn’t change and it is creating a problem with counting in 10:03
Places help
Check if the IDs in your data before unpivoting are unique to each respondent.
Also ensure you check "Add this to the data model"
Can you please submit other multiple response platforms Such Data from kobo please
Definitely. Coming up in subsequent videos in this series.
This is helpful to me. Can you please add how to handle multiple responses in separate columns?
@@abdul-wahabinusah3340 Check this out. The coded versions(1/0, Yes/No and True/False) come up next. ua-cam.com/video/Uman2Q4laBE/v-deo.html&lc=UgzQD5gGvQ428Ix1c3B4AaABAg
Please, I can't add to the data model. How do I go about it
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.
@@MSurveyPoint
Yhyh...I did but it doesnt allow me to check the add this data to data model
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
How u select the three columns together in 7:00 pleasssseeeee tell me how 😭😭😭😭😭😭😭😭😭😭😭
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
@@MSurveyPoint OMG, It’s working, thanks a lot
@@ZainabAbbas_H Glade this helped.
Feel free to check out other videos on multiple responses and Likert scale survey data.
Kindly subscribe to support me
nice job. but please give the files
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
Where is it....please put it
@@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
You can download