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
Solved! Go to Solution.
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.