I've worked with a lot of survey data, and I can tell you there's a specific way to set up your data that just makes everything infinitely easier. That is:
[Respondent ID] , [Demographic Info About Respondent], [Question], [Response]
In your case:
NAME , CATEGORY, RESPONSE
See attached Excel for details on this setup - I added a new tab with the desired layout. And in the workbook, you can see how easy it is in this format to do your desired view. And it's also simple to do scoring based on that, if you were to code Satisfied as 1 and Not Satisfied as 0, for example.
Hope this helps!
This is exactly what i was looking for. Thanks so much!!!
Now I just need to reconfigure the survey itself (from an online platform) to produce results in this form.