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