Not sure how to describe - Pivot Table setup question

Updating to include sample dataset & format excel file

Further, not sure if this is possible given the dataset/survey responses.


I'm not even sure how to go about describing what I want, so I'm not sure how to look up what I want in past answers. Apologies if this information is somewhere else on this forum.

I have data from a survey that I want to put in a table with the ability to filter by service area/line. I'm pretty sure I need to alter my data using Power Query, but I'm not sure how to alter the data so that it can pivot in the way I need.

Any and all help is much appreciated.