Count non numeric with pivot tables

[Jenst]

Hi! I have a table in which I have three non numeric columns and I want to count them(G1,simplyfied). I only get it managed to count one of the columns in a pivot table, but I want to have the result you can see in G3 in a pivot table.
Has anyone an idea how to do it, at first without vba?
G1

Rating1	Rating2	Rating3
a	a	b
a	b	b
a	a	b
c	c	a

<tbody>
</tbody>

G3

Category	Count
a	6
b	4
c	2

<tbody>
</tbody>

Many thanks, Jens​

​

Cross-posted: http://www.excelguru.ca/forums/showthread.php?6769-Count-with-pivot-tables-non-numeric

 

[Peter_SSs]

Welcome to the MrExcel board!

To get a PivotTable with Categories as you have shown, they would need to be in a single column, not scattered across 3 columns.

Is there only 3 columns of 'Ratings' in the original data?

About how many rows of data is there?

 

[sheetspread]

Your example isn't difficult to solve with the reverse pivot method shown here:

https://vimeo.com/184209158

But if the actual data is more complex (as Peter implied) then we'd need to know more