Pivot Table Filter For Multiple Survey Responses

[Sheepeys]

Hi!
I have a spreadsheet with data from a survey: 9 questions, each with an answer between 1 and 5. I have a pivot table that shows me a breakdown of how many of each answer (1 through 5) there is for a single question. Is there a way that I can include all of my data and filter by question, so I don't need to create 9 different pivot tables, but I can still see the information for a single question?

I'm unsure how to attach a file, but here is a link to my spreadsheet on Google Drive ("Sheet 1" is my current attempt at a pivot table):
https://drive.google.com/file/d/1gRYVuhFjkMkqFJvUmMp7ol0psoHI3WBn/view?usp=sharing

Thank you!

 

[sandy666]

you will need PowerQuery aka Get&Transform

use Data tab, select whole source table, then on the ribbon From Table, it will open PQ Editor, select all Q columns, from the PQ Editor ribbon choose Unpivot only selected columns, then Close& Load to.., choose Only Create Connection, OK.

next Insert - Pivot Table - Use External data source - select Query Table, choose target place

next you can do what you want

example

 

[Sheepeys]

Thank you so much! I really appreciate the help!

 

[sandy666]

you are welcome