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.
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: th-cam.com/video/JJjM2MpW0lw/w-d-xo.html 2. How to Analyze Columns-separated Multiple Response Survey Data in Excel Pivot Table: th-cam.com/video/Uman2Q4laBE/w-d-xo.html 3. How to Analyze 1/0 coded Multiple Response Survey Data in Excel Pivot Table: th-cam.com/video/kdeT4O01nmU/w-d-xo.html 4. How to Analyze TRUE/FALSE coded Multiple Response Survey Data in Excel Pivot Table th-cam.com/video/xUY2rJddT3E/w-d-xo.html 5. How to Analyze Yes/No coded Multiple Response Survey Data in Excel Pivot Table th-cam.com/video/_e_RX4e2Y5w/w-d-xo.html
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.
Hi, Thank you so much for this video. I have a multiple choice question in which most responses are blank for every option. Is there a way to get the % of the total number of survey respondents without manually adding a formula? I am using MS Excel 2016.
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.
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?
@@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
@@andrewtirtawijaya5627 If you still support, you can send me an email msurveypoint@gmail.com Note that a small consultation fee is applied for an hour session. All the best
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 Glade this helped. Feel free to check out other videos on multiple responses and Likert scale survey data. Kindly subscribe to support me
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.
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.
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
@@abdul-wahabinusah3340 Check this out. The coded versions(1/0, Yes/No and True/False) come up next. th-cam.com/video/Uman2Q4laBE/w-d-xo.html&lc=UgzQD5gGvQ428Ix1c3B4AaABAg
@@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
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.
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:
th-cam.com/video/JJjM2MpW0lw/w-d-xo.html
2. How to Analyze Columns-separated Multiple Response Survey Data in Excel Pivot Table:
th-cam.com/video/Uman2Q4laBE/w-d-xo.html
3. How to Analyze 1/0 coded Multiple Response Survey Data in Excel Pivot Table:
th-cam.com/video/kdeT4O01nmU/w-d-xo.html
4. How to Analyze TRUE/FALSE coded Multiple Response Survey Data in Excel Pivot Table
th-cam.com/video/xUY2rJddT3E/w-d-xo.html
5. How to Analyze Yes/No coded Multiple Response Survey Data in Excel Pivot Table
th-cam.com/video/_e_RX4e2Y5w/w-d-xo.html
Perfect explanation to multiple response questions. You can't imagine how it helped me Thank you so much
Oh my God, you are soooo good. This is a life saver! Thank you!
Glad this helps, Faith.
LIFESAVER!!! can't express how helpful this was :D
Cross-tabulation of multiple response survey data in Excel Pivot Tables
th-cam.com/video/WX5hLOfC1R0/w-d-xo.html
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
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.
Amazing video, thank you!!
Glad you liked it!
Thank you.
Hi, Thank you so much for this video. I have a multiple choice question in which most responses are blank for every option. Is there a way to get the % of the total number of survey respondents without manually adding a formula? I am using MS Excel 2016.
Adding to my previous question. This situation results in the grand total being less than the total number of survey respondents.
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.
Good day. I am having trouble pasting the data back into my Excel sheet; the Import Data dialog is not popping up.?//?
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?
@@andrewtirtawijaya5627
Check this video
From 3 minutes on
th-cam.com/video/WX5hLOfC1R0/w-d-xo.htmlsi=mYS4jfkmDtUL3NKb
@@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
@@andrewtirtawijaya5627
If you still support, you can send me an email msurveypoint@gmail.com
Note that a small consultation fee is applied for an hour session.
All the best
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
@@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
Check if the IDs in your data before unpivoting are unique to each respondent.
Also ensure you check "Add this to the data model"
why do you unpivot, an not only Data - Sapparete from comma - Select data to appear in rows - Transform Trim - And add to data model?
@@dajanabushpepa4389
That's another way to o handle it.
I have used that approach too in a separate video.
Thanks for the reminder
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.
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
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. th-cam.com/video/Uman2Q4laBE/w-d-xo.html&lc=UgzQD5gGvQ428Ix1c3B4AaABAg
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
Thank you so much for the great work done!