Summarize and Transpose

[LincolnMike]

Hello and good evening my Alteryx friends.  Happy post voting day!  I the following and I need some support

INPUT

unit	store	expenseCd	cost
123	ab660	rental	100
123	ab660	other	99
456	cx790	rental	1200
456	cx790	other	68
456	cx790	add	1000

I need the following Output.  One row for the unit, displaying as many expense codes listed (usually no more than 6), and summarize the cost.

unit	store	expenseCd1	expenseCd2	expenseCd3	CostSummary
123	ab660	rental	other		199
456	cx790	rental	other	add	2268

Your help is most appreciated.  

[DavidP · Accepted solution]

How about something like this?

[yalmar_m]

This solution might help as well (if the number of ExpenseCd's doesn't exceed 6).

[LincolnMike]

Hi Yalmar,

i wasn't exactly clear on the setup for your solution.  I did try based on the image, but I am still getting multiple lines instead of 1.

[LincolnMike]

Thank you David.  This worked.  I will try and apply it to the 1 million records and see if I have any hiccups.