How to combine multiple values for one item separated by a coma

Roman_K

There are multiple lines (column titled: PO Number, one on each line) for a given item number in my data. I want to combine all of the results for PO Number so they appear on one line, separated by a comma (shown at the bottom).

Item Number	PO Number
63631	235084
63631	231656
63631	227775
63631	235084
63631	231656
63631	227775

Item Number PO Number

63631 235084, 231656, 227775, 235084, 231656, 227775

MarkSnodgrass

You can do this in Magic ETL with the group by tile and using the group_concat function.

Results in this:

MarkSnodgrass

You can do this in Magic ETL with the group by tile and using the group_concat function.

Results in this:

Utz

@MarkSnodgrass I had a follow-up question on this same question is there any way to achieve this same solution via beast mode? I am having a tough time using the magic etl tool.