add dates in between and rearrange the format from columns to rows

[michaelmedaflor]

Please if you can help me add dates in between and rearrange the format from columns to rows

    Mytable

VacStartDate	VacEndDate	Emp
28/01/2018	02/02/2018	140115
23/01/2018	24/01/2018	140009

  Desired results.

Date	Emp
28/01/2018	140115
29/01/2019	140115
30/01/2020	140115
30/01/2021	140115
31/01/2022	140115
01/02/2023	140115
02/02/2024	140115
23/01/2018	140009
24/01/2018	140009

Regards,

Mike

[rupamjyotidas]

Did you try building a calendar using interval match of VacStartDate and VacEndDate. You will find many examples for the same in the community.