Hello,
I have employee data like below
Employee_ID Date Previous_FTE FTE
1 2016-03-24 1 0,67
1 2016-04-24 0,67 0,8
I would like to have final out like below
Employee_ID Start_date End Date FTE
1 2016-01-01 2016-03-24 1
1 2016-03-24 2016-04-24 0,67
1 2016-04-24 2016-12-31 0,8
This is one example in the file a have multiple lines. Initial input can have more than 2 lines for each employee but convert logic will be the same.
Thank you for help!