I am trying to create a sheet that will look at some source data in sheet 1 and present it in a different way on sheet 2.
In my final summary (sheet 2) I am trying to achieve a list of dates and then under that everyone who is off on that day e.g.
The source data contains a list of dates staff are off but some entries span a number of days like below. I want these to be repeated under each day's heading rather than just under the start date if that makes sense?
Any advice would be greatly appreciated.
In my final summary (sheet 2) I am trying to achieve a list of dates and then under that everyone who is off on that day e.g.
The source data contains a list of dates staff are off but some entries span a number of days like below. I want these to be repeated under each day's heading rather than just under the start date if that makes sense?
Any advice would be greatly appreciated.