How to Analyze Columns-separated Multiple Response Survey Data in Excel Pivot Table

This video you will walk you through how to analyze multiple choice survey data where the response appear in separate columns.

BONUS: Learn how to divide the count of the responses by the Number of Respondents for that question inside a pivot table.

Check out this previous videos on multiple response survey data
1. How to analyze comma-separated multiple response survey data:
2. How to analyze space-separated multiple response survey data:

[MSurveyPoint]

Connect with me if you need support on the following services

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.

[wiszewska]

Thank you, random Indian guy. You saved my life. Again.

[NicoleNotarioRisk]

I've come back to your video several times to help me understand something I'm working on. Thanks so much!

[chloeludden]

Thank you so much you really made my day you know. All the best from London ! Such a game changer to have knowledgeable people like you on Youtube <3.

[ahmedabdulahimahamud]

I am always with your videos nice explanation.

[SP-gfti]

Thank you for this video! It is very helpful. Do you know what to do if the Count of Id and Distinct Count of Id are listed as the same values in tge pivot table, even while the grand totals are different? Any idea why this would happen?

[ahmedabdulahimahamud]

Thank you bro, can you please analyze with other variable such District, location or Male and Female

[abdoulayebadji]

Thanks so much. How can I export multiple response variable in single column with comma (, ) separated responses

[soni_b]

Thank your for your helpful video but for some reason my ID column isnt showing on the pivot chart? What did i do wrong?

[marylusenie]

thanks so much. but I am just curious to know this. When you add the percentage of the distinct count of ID, it is more than 100%. Why is that?

[samanthagaulin]

Is there a way to use a slicer with this method?

[anaeducruz]

Can’t find the distinct count on my excel any alternatives?

[emmamichile]

How do I analyse data for multiple response answers. e.g. where a person is allowed more than one option. if a question allows a person to select that they use Phone, Tablet and TV, and others Phone and Tablet.