Showing Priority in a PIVOT

[Nina579]

Hi all,

I have a question regarding Pivots and their ability to analyse priorities.
We did a survey at my company where people were asked to assign priority to issues.

Now the source data for my Pivot is formatted like a matrix. It has a separate column for each question and values from 1-5 in that column which indicate priority. You can see it in the sample file I attached.

Is there a way to create a PivotTable which will have the questions as rows, the Priority rating as columns and the count of each rating as values? I've been trying to set up Calculated Fields for Priorities, but I failed miserably.

If that's not possible, do you have any recommendations on how I should format/aggregate the source data so that a PivotTable can analyse it?

Thank you!
Nina