Create new rows

[jaiiracha]

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!!

[Felipe_Ribeir0]

Hi @jaiiracha 

See if this is it:

[jrgo]

@jaiiracha 

Doesn't match the table layout of the "Target" in your example, but I think is directionally what you're looking for.