SOLVED
Copying over data across multiple rows
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
griseldagomes
8 - Asteroid
‎04-28-2023
06:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
For the below set of data, I need to copy over columns 2, 3, 4 onto a new row depending on how many issues exists.
For exmaple, on row 1, there are 3 issues, hence row 1 will be split into row 1, 2, 3 and data from columns 2, 3 and will be copied over onto rows 2 and 3.
Note: Number of issues could be much more.
Issue Type | Name | Status | Amount |
Issue 1: Issue 2: Issue 3 | John | Pending | 125 |
Issue 2 | Peter | Failed | 5846 |
Issue 4:Issue 2 | James | Not Started | 98787 |
Issue 3: Issue 1: Issue 5: Issue 4 | Jane | Diverted | 24587 |
Below is the expected data. Any help would be appreciated.
Issue Type | Name | Status | Amount |
Issue 1 | John | Pending | 125 |
Issue 2 | John | Pending | 125 |
Issue 3 | John | Pending | 125 |
Issue 2 | Peter | Failed | 5846 |
Issue 4 | James | Not Started | 98787 |
Issue 2 | James | Not Started | 98787 |
Issue 3 | Jane | Diverted | 24587 |
Issue 1 | Jane | Diverted | 24587 |
Issue 5 | Jane | Diverted | 24587 |
Issue 4 | Jane | Diverted | 24587 |
Thanks,
Griselda
Solved! Go to Solution.
Labels:
- Labels:
- Designer Integration
2 REPLIES 2
MilindG
12 - Quasar
‎04-28-2023
06:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎04-28-2023
06:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks a lot Milind!
