Question with multiple answers is the main reason why Pivot Table can not be used to analyze survey data in Excel. Common data format in Excel is to separate the multiple answers into multiple columns, requiring complicated formula for calculation, if Excel is used for analysis at all. Google Forms data format is unique and much simpler actually, that it put all answers for a question into one column whether it is a single answer or multiple answers. We have developed Splitter, an Excel add in program, that works just like pivot table to analyze survey data in Excel with format following that of Google Forms.

The post link on LinkedIn here.