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
