I have a calendar of guests arriving on a day and those leaving on that day.
I want to have it one taable with columns
the file attached shows how far I have got so far.
i do not know how to bring the four columns of Dates into one Column - I suspect it is using one of the options for Unpivot.
Any solutions - NB I need to use this with PQ in Excel
ACBK.xls (65.5 KB)