SOLVED
transpose number from column to row
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Taxguy03
9 - Comet
12-22-2020
11:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Workflow
2 REPLIES 2
Kenda
16 - Nebula
12-22-2020
11:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
12-23-2020
09:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Kenda , sorry for the late reply. This is exactly what I wanted. Thanks again.