Spreadsheet: 844071d1695884283-how-to-aggregate-data-based-on-multiple-criteria-inventory-tracking
Sheet: Sheet1

Cust. Order No. | Qty | Qty In transit | PCB Model | In transit ? | Required ETA
CZ10462 | 1 |  | 11T40S4000-3D.007 |  | 2023-06-08 00:00:00
CZ10462 | 1 |  | 11T40S4000-3D.007 |  | 2023-06-07 00:00:00 |  |  | Sep 2023 | Oct 2023
CZ10462 | 1 |  | 11T40S4000-3D.007 |  | 2023-06-15 00:00:00 |  | 11T40S4000-3D.007 | 2 | 9
CZ10462 | 5 |  | 12T40S5000-5D.003 |  | 2023-08-08 00:00:00 |  | 12T40S5000-5D.003 | 0 | 9
CZ10462 | 5 |  | 12T40S5000-5D.003 |  | 2023-08-15 00:00:00
CZ10462 | 1 |  | 11T40S4000-3D.007 | yes | 2023-10-11 00:00:00
CZ10462 | 2 |  | 11T40S4000-3D.007 |  | 2023-08-22 00:00:00
CZ10462 | 1 |  | 11T40S4000-3D.007 |  | 2023-07-18 00:00:00
CZ10462 | 1 |  | 11T40S4000-3D.007 |  | 2023-07-25 00:00:00
CZ10462 | 2 |  | 11T40S4000-3D.007 | yes | 2023-09-22 00:01:00
CZ10462 | 2 |  | 11T40S4000-3D.007 | yes | 2023-10-09 00:01:00
CZ10462 | 2 |  | 11T40S4000-3D.007 | yes | 2023-10-13 00:00:00
CZ10462 | 5 |  | 12T40S5000-5D.003 | yes | 2023-10-20 00:00:00
CZ10462 | 2 |  | 11T40S4000-3D.007 | yes | 2023-10-23 00:00:00
CZ10462 | 4 |  | 12T40S5000-5D.003 | yes | 2023-10-23 00:00:00
CZ10462 | 2 |  | 11T40S4000-3D.007 | yes | 2023-10-25 00:00:00
CZ10462 | 1 |  | 11T40S4000-3D.007 | no | 2023-11-26 00:00:00
CZ10462 | 1 |  | 11T40S4000-3D.007 | no | 2023-11-26 00:00:00
CZ10462 | 2 |  | 11T40S4000-3D.007 | no | 2023-11-08 00:00:00
CZ10462 | 2 |  | 11T40S4000-3D.007 | no | 2023-11-15 00:00:00
CZ10462 | 2 |  | 11T40S4000-3D.007 | no | 2023-12-20 00:00:00
CZ10462 | 3 |  | 13T40S7000-7D.005 | no | 2024-01-03 00:00:00
CZ10503 | 3 |  | 12T40S5000-5D.003 | no | 2024-03-31 00:00:00
CZ10503 | 2 |  | 12T40S5000-5D.003 | no | 2024-03-31 00:00:00
CZ10503 | 1 |  | 12T40S5000-5D.003 | no | 2024-03-31 00:00:00
CZ10503 | 1 |  | 12T40S5000-5D.003 | no | 2024-03-31 00:00:00
CZ100504 | 3 |  | 14T40S8000-8D.006 | no | 2024-04-08 00:00:00
CZ100504 | 2 |  | 14T40S8000-8D.006 | no | 2024-04-08 00:00:00
CZ100508 | 1 |  | 13T40S7000-7D.005 | no | 2024-04-12 00:00:00
CZ100502 | 2 |  | 13T40S7000-7D.005 | no | 2024-04-12 00:00:00
CZ100502 | 2 |  | 13T40S7000-7D.005 | no | 2024-05-04 00:00:00
CZ100504 | 3 |  | 14T40S8000-8D.006 | no | 2024-04-28 00:00:00
CZ100502 | 2 |  | 13T40S7000-7D.005 | no | 2024-05-04 00:00:00
CZ100507 | 3 |  | 12T40S5000-5D.003 | no | 2024-05-11 00:00:00
CZ100509 | 4 |  | 15T40S9000-9D.007 | no | 2024-05-31 00:00:00
CZ100507 | 1 |  | 12T40S5000-5D.003 | no | 2024-06-05 00:00:00
CZ100505 | 2 |  | 16T40S4000-4D.001 | no | 2024-06-15 00:00:00
CZ100505 | 2 |  | 16T40S4000-4D.001 | no | 2024-06-15 00:00:00
CZ100508 | 3 |  | 13T40S7000-7D.005 | no | 2024-06-10 00:00:00
CZ100505 | 4 |  | 16T40S4000-4D.001 | no | 2024-07-06 00:00:00
CZ100507 | 6 |  | 12T40S5000-5D.003 | no | 2024-07-13 00:00:00
CZ100569 | 3 |  | 11T40S4000-3D.007 | no | 2024-07-31 00:00:00
CZ100505 | 2 |  | 16T40S4000-4D.001 | no | 2024-08-03 00:00:00
CZ100550 | 3 |  | 12T40S5000-5D.003 | no | 2024-05-31 00:00:00
CZ100506 | 1 |  | 17T40S3000-4D.002 | no | 2024-03-31 00:00:00
CZ100550 | 3 |  | 12T40S5000-5D.003 | no | 2024-05-31 00:00:00
CZ100550 | 3 |  | 12T40S5000-5D.003 | no | 2024-05-31 00:00:00
CZ100569 | 3 |  | 11T40S4000-3D.007 | no | 2024-10-01 00:00:00
CZ100550 | 2 |  | 12T40S5000-5D.003 | no | 2024-05-31 00:00:00
CZ100550 | 3 |  | 12T40S5000-5D.003 | no | 2024-05-31 00:00:00
CZ100550 | 2 |  | 12T40S5000-5D.003 | no | 2024-05-31 00:00:00
CZ100506 | 1 |  | 17T40S3000-4D.002 | no | 2024-03-31 00:00:00
CZ100502 | 4 |  | 13T40S7000-7D.005 | no | 2024-11-02 00:00:00
CZ100550 | 4 |  | 12T40S5000-5D.003 | no | 2024-05-31 00:00:00
CZ100506 | 4 |  | 17T40S3000-4D.002 | no | 2024-03-31 00:00:00
CZ100506 | 1 |  | 17T40S3000-4D.002 | no | 2024-03-31 00:00:00
CZ100563 | 4 |  | 17T40S3000-4D.002 | no | 2024-09-30 00:00:00
CZ100563 | 4 |  | 17T40S3000-4D.002 | no | 2024-09-30 00:00:00