List all distinct values grouped by column

Question

Hi everyone,

What would be the best way to list all the distinct values of my input data grouped by column?

I know I can achieve that by setting a Unique tool for each of my columns, but I have lots of columns, and it would be better if I could automate that.

Thanks in advance.

MarqueeCrew · Accepted Answer

If you TRANSPOSE the data and uncheck any columns that have know discrete values (e.g. Acct number, address, sales amount) then you can use the UNIQUE tool on Name & Value to see your list.