Tabular Transformation.

[smoskowitz]

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

[mborriero · Accepted 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.

[smoskowitz]

I knew it had to be simple. Thank you so much.

[Drewmeister]

I'm stuck on transforming some location data. I have it vertically, but want it horizontally. I've attached an excel file showing what Im trying to accomplish. Can anyone help.