Hi - In the following dataset, I would like to create new rows, If the same employee (Employee ID) has multiple tasks fields filled out in the same row. So for example, for the first row, I'd like to create a new row with the same Employee ID, First Name and Last Name with the Date 2 and Task 2 values populated under the Date 1 and Task 1 columns.
Employee ID | First Name | Last Name | Date 1 | Task 1 | Date 2 | Task 2 | Date 3 | Task 3 |
85426 | John | Smith | 1/1/2023 | Dummy1 | 1/5/2023 | Dummy2 | ||
85426 | John | Smith | 1/1/2023 | Dummy2 | 1/7/2023 | Dummy2 | ||
85426 | John | Smith | 1/1/2023 | Dummy3 | 1/5/2023 | Dummy2 | ||
85426 | John | Smith | 1/1/2023 | Dummy1 | 1/5/2023 | Dummy2 | 1/8/2023 | Dummy3 |
Example:
Source:
Employee ID | First Name | Last Name | Date 1 | Task 1 | Date 2 | Task 2 | Date 3 | Task 3 |
85426 | John | Smith | 1/1/2023 | Dummy1 | 1/5/2023 | Dummy2 |
Target:
Employee ID | First Name | Last Name | Date 1 | Task 1 | Date 2 | Task 2 | Date 3 | Task 3 |
85426 | John | Smith | 1/1/2023 | Dummy1 | ||||
85426 | John | Smith | 1/5/2023 | Dummy2 |
Thank you! Appreciate the help!!
Doesn't match the table layout of the "Target" in your example, but I think is directionally what you're looking for.