Concatenate multiple values for the same key

[R00]

Hey Alteryx community,

I'm attaching a small excel file cause I'm having a problem posting a table on here.

The original data set and the desired outcome.

Please assist, I tried cross tab and multi row but I don't seem to be able to achieve this..

Any help would be much appreciated!

Thank you!

[Shaaz]

Please refer the attached workflow. This should solve your issue.

[R00]

Hey shaaz,

I can't seem to be able to open that package..

Thank you

[Shaaz]

Please open it with latest version of Alteryx i.e, v11.3.

If still you are not able to, please share the screenshot of issue that you are facing.

[Shaaz · Accepted solution]

Attached is the .yxmd file, please use this workflow

[AmitBelagali · Accepted solution]

Hi R00,

Please add a summarize tool and add ID as GroupBy, Description as Concat and Price as Sum. attached is the screenshot for your reference. Do let me know if this works for you. 

Thanks, 

Amit Belagali

[AmitBelagali]

Hi R00,

Were you able to get the desired output? If not, do let me know.

Thanks,

Amit Belagali

[R00]

That's perfect Amit! thank you so much :)

[R00]

Thank you so much shaaz!! :)