Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Did you try building a calendar using interval match of VacStartDate and VacEndDate. You will find many examples for the same in the community.