Pivot Table - Adding Rows with Zero Values

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

Thanks for the reply, Playaller, but your example isn't my situation. I don't have counts of each value, I just have the value themselves. (Taking the counts would be difficult as the real data I'm trying to use is huge.

Attached is an example of my data using your method. It doesn't work ):

Attachment: Example.xlsx

I was afraid that doing countif's would be the only solution... ): Oh well.

Thank you for your help and patience