SOLVED
How to rearrange data?
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
gc-804
7 - Meteor
‎03-31-2020
04:44 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I have 10 columns with headers Description 1 to 10. This is a small sample for example purpose:
Box Number | Description 1 | Description 2 | Description 3 | Description 4 |
20 | ABC | DEF | ||
44 | CCC | |||
46 | AAA | BBB | ||
52 | FFF | EEE |
How to combine the multiple descriptions in the same row that have the same box number into one column with a new header "Description" while maintaining the box number in the Box Number column like the output below?
Box Number | Description |
20 | ABC |
20 | DEF |
44 | CCC |
46 | AAA |
46 | BBB |
52 | EEE |
52 | FFF |
Thanks!
Solved! Go to Solution.
Labels:
- Labels:
- Transformation
2 REPLIES 2
fmvizcaino
17 - Castor
‎03-31-2020
04:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @gc-804 ,
Attached is a solution showing how to do it.
Let me know if you need further assistance.
Best,
Fernando Vizcaino
‎03-31-2020
05:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator