transpose number from column to row

[Taxguy03]

Hi community,

I can’t seem to transpose the number from column to row. I used cross tab, RegEx, Summarize tools but nothing seems to be working. Appreciate any help. 

Points (Before)

50;51;52

53;54

55

56;57;58

Points (After)

50,51,52,53,54,55,56,57,58

[Kenda · Accepted solution]

Hi @Taxguy03 

What if you used a Summarize tool to concatenate all records in your Points field? You could use a semi colon as the separator then use a formula tool to change all semi colons to commas, if you wanted. 

Hope this helps!

[Taxguy03]

@Kenda , sorry for the late reply. This is exactly what I wanted. Thanks again.