I would suggest 3 tables.

Drop Site and Q1 into Row Fields and then drop QA into Data fields as well.

Do the same in table 2 using Q2 instead, and table 3 with Q3...

"Michael" wrote:

Hi Folks - I have survey data like this:

Site Q1 Q2 Q3
SiteA 1 3 2
SiteA 2 2 1
SiteA 2 1 3
SiteB 1 1 1
SiteB 2 1 3
etc.


How can I use a pivot table to count the number of 1's, 2's and 3's for each
question by site? Thanks for your help.

Michael