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

SampleData.xlsx

atcodedog05

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 😀👍

cmv.yxmd