Is there a way to count unique records such as Red Red Red Yellow Green Green Transpose into Red 3 Yellow 1 Green 2

Count Unique Records

Is there a way to count unique records such as

Red

Yellow

Green

Transpose into

Red 3

Yellow 1

Green 2

Parse

Summarize tool is perfect for this job

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

The Summarize tool has a Count Distinct function.

Summarize tool is perfect for this job

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

Thanks! would this then be easy to output into charting?