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 separate each answer in multiple answer question. And since we also use comma the same way in writing, ie to separate clauses/items (I like the brand because price is cheap, good build quality, large screen, upgradable OS, long battery life), Splitter can be used to analyze open end question.

The link post on LinkedIn here.