Creating new column and count

[RandomPezzer]

Morning, 

Sorry if this has been covered already. 

I have a list of data by name, type of transaction, transaction code. 

I need to group it altogether but in a column format instead of row. 

for example this is how I've managed to get Alteryx to group it and to filter out 'Cancelled' in type of transaction. 

Name	Type of Transaction	Transaction code	Count
Rob	New	CMV	2
Rob	Existing	PMC	1
Rob	New	TSL	4
John	Existing	TSL	2
John	Existing	PMC	4
John	New	CMV	3
Betsy	New	PMC	8
Betsy	New	TSL	6
Betsy	New	CMV	4

But I want it to show only the name once and the Count in a column format for each new or existing transaction code

For example: 

Name	PMC New	CMV New	TSL New	PMC Existing	CMV Existing	TSL Existing
Rob	0	2	4	1	0	0
John	0	3	0	4	0	2
Betsy	8	4	6	0	0	0

Any help would be greatly appreciated. 

I have attached sample data to try an help understand my data easier. 

Many Thanks

[atcodedog05 · Accepted solution]

Hi @RandomPezzer 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[RandomPezzer]

That's amazing thank you. 

If the Data didn't have a count column for example in excel to create a count i would use countifs (=COUNTIFS(A:A,"Rob",B:B,"New",C:C,"PMC") 

Is there anyone in Alteryx to create that count? then produce the same outcome you've just shown me. 

[atcodedog05 · Accepted solution]

Hi @RandomPezzer 

You can use summarize tool to grouby and count.

Updated the workflow with the file as data source.

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[RandomPezzer]

@atcodedog05 Thank you for your help. 

[atcodedog05]

Happy to help 🙂 @RandomPezzer 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂