The spreadsheet illustrates what is needed, easy enough to do when the dates are different but need to be able to consolidate by date. The desired output is in Columns C and D. The user does not have Excel 365 and is using Excel 2016. I'm after a formula solution, helper columns are ok if no other solution exists. Power query/VBA solutions will do if the formulaic solution is not practical.
Book5 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Date | Description | Date | Description | |||
2 | 1/01/2023 | Room A hired 3 hours | 1/01/2023 | Room A hired 3 hours, Room B hired 2 hours | |||
3 | Room B hired 2 hours | 2/01/2023 | Room C hired 1 hour, Materials usage low, Room A hired 1 hour, Room E hired 1 hour, Room D hired 2 hours | ||||
4 | 2/01/2023 | Room C hired 1 hour | 4/01/2023 | Room A hired 3 hours etc | |||
5 | Materials usage low | ||||||
6 | 2/01/2023 | Room A hired 1 hour | |||||
7 | Room E hired 1 hour | ||||||
8 | Room D hired 2 hours | ||||||
9 | 4/01/2023 | Room A hired 3 hours | |||||
10 | Room B hired 2 hours | ||||||
11 | Materials required | ||||||
12 | Order required | ||||||
Sheet2 |