Count Values across multiple columns

[BD1]

Hi all,

Little bit stuck, hoping someone can point me in the right direction.

I have a table with customer IDs in the first column followed by 10 columns with characteristics, all 10 columns are the same (but named rule 1, rule 2, rule 3 etc) and I would like to count the number of times A B C D E F or G occurs across all columns.

Thanks

BD

[kaushiknsolanki]

Some sample data will help us understand how the data look like.

If possible please share the sample data along with expected result.

[BD1]

Thanks Kaushik, please see below:

ID	Rule 1	Rule 2	Rule 3	Rule 4
001	A	C	F	B
002	B	A
003	A
004	B	A
005	C	A
006	F	A	F	B
007	D	A	B
008	E	B
009	E	B
010	A
Expected result:
i.e. total count of A's across all columns, so for A this would be 8