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 |
Solved! Go to 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!
@Kenda , sorry for the late reply. This is exactly what I wanted. Thanks again.