Previous posts showed how to use Splitter to analyze survey data in Excel downloaded from Google Forms or exported from Survey Monkey. Splitter can also handle survey data entered in Excel from survey using pen paper, ie row for respondents and column for question answers. For multiple answer separate each answer with a comma sign-within…
In previous post, Survey Monkey survey data in Excel is rearranged to follow Google Forms format to allow Splitter to do deep dive. One of Splitter key function is to handle question with multiple answers. It splits multiple values/contents in a cell by splitting it into its individual value/content. Google Forms uses comma sign to…
In Survey Monkey website, there is an example of Survey Monkey survey raw data exported to Excel, a copy can be downloaded here. As mentioned in previous post, question with multiple answer is the main reason you can not use Pivot Table, notice that question with multiple answers are separated into multiple column, the common…