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 survey data format in Excel. Had the survey been conducted using Google Forms, the format would’ve looked like a file in my comment. Notice the difference. So if you are using other online survey platform, you need to rearrange the Excel data to follow that of Google Forms in order for Splitter to analyze.

The link post on LinkedIn here.