I have a table which has multiple columns and large number of rows. A sub sample give below , in this case Name1-Name4 are different column names which coded with two character values. Name1 Name2 Name3 Name4 AA BB CC DD AA AA BB EE FF FF CC CC AA AA AA AA BB BB BB ZZ I am interested in finding distinct in number of characters in each row . that is final output table has to look like this Name1 Name2 Name3 Name4 Count AA BB CC DD 4 AA AA BB EE 3 FF FF CC CC 2 AA AA AA AA 1 BB BB BB ZZ 2 In the first row all the elements are distinct , so the count is 4. In second row there are 3 distinct values [AA,BB,EE]. Similarly for others Can you please help to solve this issues without using multiple if-else statements. Thanks, Yoonus
... View more