How to get table in Alteryx into pivot-table like format

[saiabhijitpabbisetty]

Hello,

I am trying to format a table in Alteryx to get it into a similar format that the pivot table function in excel uses. The input data is in a format such as this below...

Manager	Employee	Count
Tom	Lucia	235
Tom	Alice	357
Tom	Chris	214
David	Sauruv	333
David	Rahul	111
Alicia	Rohit	2222
Alicia	Anish	123
Ronald	Samarth	345

I would like the format of the table to be as the following...

Employee	Count
Tom	806 (Calculated by adding below three values of 235 + 357 + 214)
Lucia	235
Alice	357
Chris	214
David	444 (Calculated by adding below two values of 333 + 111)
Sauruv	333
Rahul	111
Alicia	2345 (Calculated by adding below two values of 2222 + 123)
Rohit	2222
Anish	123
Ronald	345 (Calculated by adding below value of 345)
Samarth	345

If there is any specific tool or solution that would be helpful in achieving this, that would be very much appreciated!

[cjaneczko · Accepted solution]

Its a bit clunky and will need the Regex updated to account for last names, but check out the below workflow.

[geraldo]

@saiabhijitpabbisetty 

Another example

[saiabhijitpabbisetty]

This worked perfectly. Thank you!