How to Analyze Space-separated Multiple response Survey Data in Excel Pivot Table

In this video you will learn how to analyze multiple response survey data where responses are separated by space delimiter.
BONUS: Learn how to divide the count of the responses by the Number of Respondents in the pivot table

How to analyze comma-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.

[tamandanichimguba]

one of the best videos i have ever watched

[senchihiro]

Hi. What if the my response option is a long sentence and separated by comma. However when I split by comma, there is residual sentence that have space at the front and it does not read as similar response. How do I manage this? Thank you. Your video helps a lot.

[minnie]

Hello, after dropping the data in the row (as you did at 04:53) I am getting duplicate items in the label. Excel is counting it properly, however when I'm using that table for making a pie chart, the items are getting duplicated there too. Can you please suggest a fix?