SOLVED
Combine multiple rows into one 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
nexbelgium
6 - Meteoroid
‎10-18-2017
04:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I would like to combine records that I receive in multiple rows into one row.
In short, this is my input:
UserName | Michael |
Status | Active |
Team | Sales |
Location | France |
UserName | Thomas |
Status | Not Active |
Team | HR |
Location | Belgium |
UserName | Bob |
Status | Active |
Team | HR |
Location | Spain |
And this is the what I would like as output:
UserName | Status | Team | Location |
Michael | Active | Sales | France |
Thomas | Not Active | HR | Belgium |
Bob | Active | HR | Spain |
It's a kind of transpose on the 4 first rows to be repeated. If it were only 2 'columns' per record, I could do that with the multi-row formula, taking the [row-1], but the more columns I add per record, the more complex it becomes.
Many thanks
Solved! Go to Solution.
Labels:
2 REPLIES 2
16 - Nebula
‎10-18-2017
05:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @nexbelgium! The key is to add a field that you can group by before cross-tabbing. Try the attached workflow and see if that's what you're looking for. Hope this helps!
‎10-18-2017
06:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Great, thanks it works!
