I Have these 2 reports on separate sheets which i want to create a new report using the data from the two reports. how do i combine them to one sheet with the headings:
- Order No
- Customer
- Reference
- invoice date
- actual delivery date
- Order Date
Delivery | Priority | Order No | BO Suffix | Status | Status2 | Whse | Territory | Customer | Ordered | Total Ordered Amount | Reference | Invoice Date | Actual Del. | Total Shipped Amount | Rep | Curr | Type | Price Level | Invoice | Batch | Reason | Packages | User | Processing Date | Invoice Due Date | Pickable Lines | Settlement Due Date |
24 Jan 23 | 0 | 9000017801 | 30 | R'dy Pick'g | DGW1 | 1TRA | ZDGW1 | 24 Jan 23 | 0 | INT STOCK ISSUE | 0 | I | I | 9000017801 | 1 | slomu | 24-JAN-2023 00:00:00 | 1 | 24-JAN-2023 00:00:00 | ||||||||
30 Jan 23 | 0 | 9000021026 | 40 | PSlip Prt'd | DGW1 | 1TRA | ZZBAD | 30 Jan 23 | 0 | INT STOCK ISSUE | 0 | I | I | 9000021026 | 4 | slomu | 30-JAN-2023 00:00:00 | 2 | 30-JAN-2023 00:00:00 | ||||||||
30 Jan 23 | 0 | 9000021068 | 40 | PSlip Prt'd | DGW1 | 1TRA | ZZHAA | 30 Jan 23 | 0 | INT STOCK ISSUE | 0 | I | I | 9000021068 | 135 | slomu | 30-JAN-2023 00:00:00 | 6 | 30-JAN-2023 00:00:00 | ||||||||
30 Jan 23 | 0 | 9000021071 | 40 | PSlip Prt'd | DGW1 | 1TRA | ZKIMB | 30 Jan 23 | 0 | INT STOCK ISSUE | 0 | I | I | 9000021071 | 1 | slomu | 30-JAN-2023 00:00:00 | 1 | 30-JAN-2023 00:00:00 | ||||||||
31 Jan 23 | 0 | 9000021312 | 40 | PSlip Prt'd | DGW1 | 1TRA | ZZCEN | 31 Jan 23 | 0 | INT STOCK ISSUE | 0 | I | I | 9000021312 | 70 | slomu | 31-JAN-2023 00:00:00 | 2 | 31-JAN-2023 00:00:00 | ||||||||
31 Jan 23 | 0 | 9000021316 | 40 | PSlip Prt'd | DGW1 | 1TRA | ZZTOW | 31 Jan 23 | 0 | INT STOCK ISSUE | 0 | I | I | 9000021316 | 524 | slomu | 31-JAN-2023 00:00:00 | 7 | 31-JAN-2023 00:00:00 |
Order No | Invoice Date | Customer | Order No1 | BO Suffix | Actual Del. | Invoice | Total Shipped Amount | Reference | Status | Status2 | Territory | Whse |
2889376 | 1 Dec 22 | 1DR511 | 2889376 | 1 Dec 22 | 2636986 | 2946.1 | 49 | 90 | Finished | 1WPO | DGW1 | |
2894343 | 1 Dec 22 | 1MO507 | 2894343 | 1 Dec 22 | 2637089 | 1801 | 20791 | 90 | Finished | 1WPO | DGW1 | |
2965038 | 1 Dec 22 | 1WO505 | 2965038 | 1 Dec 22 | 2636987 | 1597.6 | 2000673 | 90 | Finished | 1WPO | DGW1 | |
2966023AA | 1 Dec 22 | 1FH501 | 2966023 | AA | 1 Dec 22 | 2637072 | 157.95 | PPNG230048 | 90 | Finished | 1WPO | DGW1 |
2970809AF | 1 Dec 22 | 1IN520 | 2970809 | AF | 1 Dec 22 | 2637155 | 202.15 | IPL42690 | 90 | Finished | 1WPO | DGW1 |
2976160AA | 1 Dec 22 | 1CA509 | 2976160 | AA | 1 Dec 22 | 2637004 | 5540 | WALLACE AMURO ORIVI | 90 | Finished | 1WPO | DGW1 |
2977831AA | 1 Dec 22 | 1PA531 | 2977831 | AA | 1 Dec 22 | 2636992 | 3800 | PUR600330PNG | 90 | Finished | 1WPO | DGW1 |
2981379AA | 1 Dec 22 | 1OI502 | 2981379 | AA | 1 Dec 22 | 2637034 | 55075.45 | 4500123910 | 90 | Finished | 1WPO | DGW1 |