I've created an excel spreadsheet with the results of a survey I performed. Responses to seven distinct questions are tracked. There are 5 possible answers for each question: not at all, barely, moderately, very, and tremendously.
I am attempting to use Pivot Table to generate a table that will tally the amount of values for each of the five different sorts of responses across seven different questions, but I am unable to do so.
Desired output table:
The problem is that count values of Q1 get copied in columns for Q2, Q3, Q4, and so on. If I drag Q2, Q3, Q4 in rows of the pivot table field then it begins to separate the responses of each type, creating a big mess e.g. shown below: