Counting the amount of rows that have the same value

[aishagaldo]

Hello. I have a data set that looks like this. How would I count how many X Y and Z rows there are?

X                  

X

X

Y

Z

Z

I want the output to be (space indicating new column)

X 3

Y 1

Z 2

[atcodedog05]

Hi @aishagaldo 

You can use summarize tool groupby the column and count the rows.

Workflow:

Hope this helps : )