Spreadsheet: 857235d1706263312-group-array-items-monthly-based-on-start-and-finish-dates-group-array-based-on-start-and-finish-dates-excelforum-2501242-1-
Sheet: Sheet1

Area | Process | Start | Finish
Area 1 | Production | 2023-01-01 00:00:00 | 2023-11-02 00:00:00
Area 1 | Assembly
Area 1 | Dispatch
Area 1 | Delivery
Area 2 | Production
Area 2 | Assembly
Area 2 | Dispatch
Area 2 | Delivery
 |  | Area 1 | Area 2
 | 2023-01-01 00:00:00 | Production
 | 2023-02-01 00:00:00 | Production
 | 2023-03-01 00:00:00 | Production
 | 2023-04-01 00:00:00 | Production
 | 2023-05-01 00:00:00 | Production
 | 2023-06-01 00:00:00 | Production
 | 2023-07-01 00:00:00 | Production
 | 2023-08-01 00:00:00 | Production
 | 2023-09-01 00:00:00 | Production
 | 2023-10-01 00:00:00 | Production
 | 2023-11-01 00:00:00 | Production
 |  | Assembly
 | 2023-12-01 00:00:00 | Assembly
 | 2024-01-01 00:00:00 | Dispatch
 | 2024-02-01 00:00:00 | Delivery
 | 45352 | Delivery
 | 45383 |  | Production
 | 45413 |  | Assembly
 | 45444 |  | Assembly
 | 45474 |  | Dispatch
 | 45505 |  | Delivery
 | 45536 |  | Delivery
 |  | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00
 | Area 1 | Production | Production | Production | Production | Production | Production | Production | Production | Production | Production | Production
 | Area 1 |  |  |  |  |  |  |  |  |  |  | Assembly | Assembly
 | Area 1 |  |  |  |  |  |  |  |  |  |  |  |  | Dispatch
 | Area 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Delivery | Delivery
 | Area 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Production
 | Area 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assembly | Assembly
 | Area 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dispatch
 | Area 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Delivery | Delivery
 |  | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00
 | Area 1 | Production | Production | Production | Production | Production | Production | Production | Production | Production | Production | Production Assembly | Assembly | Dispatch | Delivery | Delivery
 | Area 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Production | Assembly | Assembly | Dispatch | Delivery | Delivery
 |  | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00
 | Area 1 | Production | Production | Production | Production | Production | Production | Production | Production | Production | Production | Production Assembly | Assembly | Dispatch | Delivery | Delivery
 | Area 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Production | Assembly | Assembly | Dispatch | Delivery | Delivery