Hello,
I want to count rows from all the columns
EID Column1 Column2 Column3
001 A B A
002 C D E
003 D A B
004 B B E
005 D C A
The out put should be
Column1 Count Column2 Count Column3 Count
A 1 A 1 A 2
B 1 B 2 B 1
etc
Can any one help me with this? I know how to count from a single column.
Many thanks