Pivot table to count & group data in columns?

[mooserus]

Is it possible to get a pivot table to count occurrences of values in columns, but group them by the data values. I.e.
Take the following list (ignore the dots, they're just for spacing in this example) :
August September October
bill ........ bill ........ bill
fred ...... fred ...... fred
bill ........ fred ....... bill

and get a pivot table to count the occurences and display as:
.... August September October
bill ... 2 ........ 1 .......... 2
fred ..1 ........ 2 .......... 1

I can do this with countif and array formulae but surely there has to be an easier way with a quick pivot table?

thanks