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

[TABLE="class: cms_table, width: 500"]
<tbody>[TR]
[TD]Rating1[/TD]
[TD]Rating2[/TD]
[TD]Rating3[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]a[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]b[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]a[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]c[/TD]
[TD]a[/TD]
[/TR]
</tbody>[/TABLE]


G3
[TABLE="class: cms_table, width: 500"]
<tbody>[TR]
[TD]Category[/TD]
[TD]Count[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]




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