Pivot Tables in MS Excel Office 365

Question

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.

Input table:

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:

Answer 1

If you create the required result table and just use the countif() function on the data to get the required result.