Hello,

I tried searching around for my issue via google and the forum search and I'm either really bad at searching or nobody has the same problem...

I have some nominal data that I'd like to get into a pivot table (Excel 2013). For simplicity let's say it's a one-question survey with 6 respondents:

Q1: Dogs are better than Cats
Strongly Agree
Agree
Neither Agree or Disagree
Disagree
Strongly Disagree

Responses:
Agree
Strongly Agree
Strongly Agree
Strongly Agree
Agree
Strongly Agree

I can create a pivot table with this data and get the following:
Row Labels Count of Q1
Strongly Agree 4
Agree 2
Grand Total 6

This all works nicely, however I require that the other options ("Neither Agree or Disagree", "Disagree", and "Strongly Disagree") be present, even if their values are 0, like the following:
Row Labels Count of Q1
Strongly Agree 4
Agree 2
Neither Agree or Disagree 0
Disagree 0
Strongly Disagree 0
Grand Total 6

What I tried doing was adding a new column and calling it something like Ratings with the following:
Ratings
Strongly Agree
Agree
Neither Agree or Disagree
Disagree
Strongly Disagree
Then I set the Ratings column in the "Rows" section of the pivot table and the Count of Q1 column in the Values section. This is what happened:
Row Labels Count of Q1
Strongly Agree 1
Agree 1
Neither Agree or Disagree 1
Disagree 1
Strongly Disagree 1
Grand Total 6

Can anyone point me in the right direction?
Thanks in advance