Hello All -
I am struggling with probably a simple issue that I can't work out. How would I transform:
name. Number
A. 100
A. 200
A. 309
B. 400
B. 500
to
A. 100,200,309
B. 400,500
I've tried grouping and transposing, but no luck.
thanks,
Seth
Hi @smoskowitz, I would use a select tool to transform the int to string, then a summarize too, suing group by Name and Concatenate by Number.
Find workbook attached.
I knew it had to be simple. Thank you so much.