Group By and count Problem

[sanjit11]

I am trying to achieve the above result. The left one is the input and the output is on the right. Can someone help out

Thanks.

[atcodedog05 · Accepted solution]

Hi @sanjit11 

You can achieve this using crosstab tool.

Workflow:

1. Creating a column count and setting values as 1.

2. Using crosstab tool with ID as key, Animal as Name and Count as values getting count table.

3. Using data cleaning tool to add 0's in place of nulls.

Hope this helps 🙂

[sanjit11]

Thanks alot atcodedog05 !