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
G3
Many thanks, Jens
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 |
G3
Category | Count | |
a | 6 | |
b | 4 | |
c | 2 |
Many thanks, Jens