Spreadsheet: 696201d1600698373-collating-multiple-tab-info-into-one-rj-projections_chrispq
Sheet: Power Query

Forecast Month | Name | [NAME] (Product) | [NAME] (Number) | Container Number | Time to arrive (M) | Order Date | Container Cost (£) | Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | [NAME] | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | Jan-21 | Feb-21 | Mar-21 | Apr-21 | May-21 | [NAME] | [NAME] | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21
Jan-21 | Supplier1 | Product A | 2000 | 1 | -3 | 2020-10-01 00:00:00 | 30000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7500 | 0 | 22500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Jan-21 | Supplier2 | Product B | 2000 | 1 | -3 | 2020-10-01 00:00:00 | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2500 | 0 | 7500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Jan-21 | Supplier4 | Product B | 2000 | 1 | -3 | 2020-10-01 00:00:00 | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2500 | 0 | 7500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Jan-21 | Supplier4 | Product B | 2000 | 1 | -3 | 2020-10-01 00:00:00 | 20000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 0 | 15000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Feb-21 | Supplier1 | Product A |  | 2 | -3 | 2020-11-01 00:00:00 | 40000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10000 | 0 | 30000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Feb-21 | Supplier3 | Product C | 2000 | 1 | -3 | 2020-11-01 00:00:00 | 20000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 0 | 15000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Feb-21 | Supplier3 | Product C | 2000 | 1 | -3 | 2020-11-01 00:00:00 | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2500 | 0 | 7500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mar-21 | Supplier1 | Product A |  | 3 | -3 | 2020-12-01 00:00:00 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12500 | 0 | 37500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mar-21 | Supplier2 | Product B | 2000 | 1 | -3 | 2020-12-01 00:00:00 | 20000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 0 | 15000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Apr-21 | Supplier1 | Product A |  | 4 | -3 | 2021-01-01 00:00:00 | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2500 | 0 | 7500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Apr-21 | Supplier2 | Product B | 2000 | 1 | -3 | 2021-01-01 00:00:00 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12500 | 0 | 37500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Apr-21 | Supplier2 | Product B | 2000 | 1 | -3 | 2021-01-01 00:00:00 | 40000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10000 | 0 | 30000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Apr-21 | Supplier4 | Product B | 2000 | 1 | -3 | 2021-01-01 00:00:00 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12500 | 0 | 37500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Apr-21 | Supplier4 | Product B | 2000 | 1 | -3 | 2021-01-01 00:00:00 | 40000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10000 | 0 | 30000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
May-21 | Supplier3 | Product C | 2000 | 1 | -3 | 2021-02-01 00:00:00 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12500 | 0 | 37500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Supplier3 | Product C | 2000 | 1 | -3 | 2021-03-01 00:00:00 | 40000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10000 | 0 | 30000 | 0 | 0 | 0 | 0 | 0 | 0 | 0