Data Transformation

Hi! Could you please help me how to transform this data from file 20 to output 20? Which tool I should use?

Datasets

Accepted answers

@howyoudoing you can try with the summarize tool

group by category,color

and take the count of the state field

@howyoudoing you can try with the summarize tool

group by category,color

and take the count of the state field

@howyoudoing Hello, you will find attached the workflow with the desired output...
just correct the color and use the group by tool