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
Hi @aishagaldo
You can use summarize tool groupby the column and count the rows.
Workflow:
Hope this helps : )