Spreadsheet: 807513d1669921710-merge-table-with-power-query-primary-key-with-duplicate-values-factory
Sheet: 2-Com_Imp

 |  | Back to Back LC |  |  |  |  |  |  |  |  | Import Consignment
 | Helper | BBLC NO | BBLC-Date | BBLC-Amount | PI Item | Order No | Export LC/ Contract No |  |  | Helper | Import consignment | PI Item | ETA | At factory | Amount | BBLC NO | Export LC/Contract No | Order No
 |  | 127 | 2022-11-05 00:00:00 |  | Fabric | JMS-001-22 | H&M-019-22 |  |  |  | 105 | Fabric | 2022-12-05 00:00:00 | 2022-12-10 00:00:00 | 300000 | 127
 |  | 131 | 2022-11-07 00:00:00 |  | Acc | JMS-001-22 | H&M-019-22 |  |  |  | 101 | Fabric | 2022-12-15 00:00:00 | 2022-12-20 00:00:00 | 65000 | 127
 |  | 135 | 2022-11-08 00:00:00 |  | Acc | JMS-001-22 | H&M-019-22 |  |  |  | 15 | Acc | 2022-12-05 00:00:00 | 2022-12-05 00:00:00 | 23560 | 131
 |  | 140 | 2022-11-10 00:00:00 |  | Acc | JMS-001-22 | H&M-019-22 |  |  |  | 25 | Acc | 2022-12-05 00:00:00 | 2022-12-05 00:00:00 | 29450 | 135
 |  | 145 | 2022-11-11 00:00:00 |  | Fabric | [NAME] | H&M-020-22 |  |  |  | 75 | Acc | 2022-12-05 00:00:00 | 2022-12-05 00:00:00 | 11780 | 140
 |  | 146 | 2022-11-12 00:00:00 |  | Acc | [NAME] | H&M-020-22 |  |  |  | 250 | Fabric | 2022-12-12 00:00:00 | 2022-12-17 00:00:00 | 350000 | 145
 |  | 148 | 2022-11-13 00:00:00 |  | Acc | [NAME] | H&M-020-22 |  |  |  | 220 | Fabric | 2022-12-20 00:00:00 | 2022-12-25 00:00:00 | 225000 | 145
 |  | 150 | 2022-11-14 00:00:00 |  | Acc | [NAME] | H&M-020-22 |  |  |  | 75 | Fabric | 2022-12-25 00:00:00 | 2022-12-30 00:00:00 | 52000 | 145
 |  | 151 | 2022-11-11 00:00:00 |  | Fabric | JMS-003-22 | Next-111-22 |  |  |  | 22 | Acc | 2022-12-15 00:00:00 | 2022-12-15 00:00:00 | 38600 | 146
 |  | 152 | 2022-11-11 00:00:00 |  | Acc | JMS-003-22 | Next-111-22 |  |  |  | 23 | Acc | 2022-12-15 00:00:00 | 2022-12-15 00:00:00 | 28950 | 148
 |  | 153 | 2022-11-11 00:00:00 |  | Acc | JMS-003-22 | Next-111-22 |  |  |  | 50 | Acc | 2022-12-15 00:00:00 | 2022-12-15 00:00:00 | 19300 | 150
 |  | 154 | 2022-11-11 00:00:00 |  | Acc | JMS-003-22 | Next-111-22 |  |  |  | 250 | Fabric | 2022-12-20 00:00:00 | 2022-12-25 00:00:00 | 390000 | 151
 |  | 160 | 2022-12-08 00:00:00 |  | Fabric | JMS-004-22 | H&M-021-22 |  |  |  | 220 | Fabric | 2022-12-25 00:00:00 | 2022-12-30 00:00:00 | 410000 | 151
 |  | 162 | 2022-12-09 00:00:00 |  | Acc | JMS-004-22 | H&M-021-22 |  |  |  | 75 | Fabric | 2022-12-15 00:00:00 | 2022-12-15 00:00:00 | 43000 | 151
 |  | 164 | 2022-12-08 00:00:00 |  | Fabric | JMS-005-22 | H&M-022-22 |  |  |  | 57 | Acc | 2022-12-15 00:00:00 | 2022-12-15 00:00:00 | 52000 | 152
 |  | 168 | 2022-12-09 00:00:00 |  | Fabric | JMS-005-22 | H&M-022-22 |  |  |  | 56 | Acc | 2022-12-15 00:00:00 | 2022-12-15 00:00:00 | 39000 | 153
 |  | 170 | 2022-12-12 00:00:00 |  | Acc | JMS-005-22 | H&M-022-22 |  |  |  | 45 | Acc | 2022-12-20 00:00:00 | 2022-12-20 00:00:00 | 32500 | 154
 |  | 171 | 2022-12-12 00:00:00 |  | Acc | JMS-005-22 | H&M-022-22 |  |  |  | 250 | Fabric | 2023-01-01 00:00:00 | 2023-01-06 00:00:00 | 400000 | 160
 |  | 175 | 2022-12-10 00:00:00 |  | Fabric | JMS-006-22 | Next-112-22 |  |  |  | 25 | Fabric | 2023-01-08 00:00:00 | 2023-01-13 00:00:00 | 33840 | 160
 |  | 178 | 2022-12-12 00:00:00 |  | Fabric | JMS-006-22 | Next-112-22 |  |  |  | 55 | Acc | 2023-01-08 00:00:00 | 2023-01-13 00:00:00 | 44660.00000000001 | 162
 |  | 180 | 2022-12-15 00:00:00 |  | Acc | JMS-006-22 | Next-112-22 |  |  |  | 250 | Fabric | 2022-12-30 00:00:00 | 2023-01-05 00:00:00 | 627250 | 164
 |  | 185 | 2022-12-18 00:00:00 |  | Acc | JMS-006-22 | Next-112-22 |  |  |  | 47 | Fabric | 2022-12-30 00:00:00 | 2023-01-05 00:00:00 | 28950 | 168
 |  | 190 | 2022-12-20 00:00:00 |  | Acc | JMS-006-22 | Next-112-22 |  |  |  | 47 | Acc | 2022-12-30 00:00:00 | 2023-01-05 00:00:00 | 57900 | 170
 |  | 195 | 2022-12-30 00:00:00 |  | Fabric | JMS-007-22 | FO-555-22 |  |  |  | 52 | Acc | 2022-12-30 00:00:00 | 2023-01-05 00:00:00 | 48250 | 171
 |  | 196 | 2023-01-15 00:00:00 |  | Fabric | JMS-007-22 | FO-555-22 |  |  |  | 550 | Fabric | 2022-12-30 00:00:00 | 2023-01-05 00:00:00 | 848250 | 175
 |  | 197 | 2023-01-16 00:00:00 |  | Fabric | JMS-007-22 | FO-555-22 |  |  |  | 55 | Fabric | 2022-12-30 00:00:00 | 2023-01-05 00:00:00 | 39150 | 178
 |  | 198 | 2023-01-18 00:00:00 |  | Acc | JMS-007-22 | FO-555-22 |  |  |  | 12 | Acc | 2022-12-30 00:00:00 | 2023-01-05 00:00:00 | 52200 | 180
 |  | 199 | 2023-01-19 00:00:00 |  | Acc | JMS-007-22 | FO-555-22 |  |  |  | 27 | Acc | 2022-12-30 00:00:00 | 2023-01-05 00:00:00 | 32625 | 185
 |  | 200 | 2023-01-25 00:00:00 |  | Acc | JMS-007-22 | FO-555-22 |  |  |  | 32 | Acc | 2022-12-30 00:00:00 | 2023-01-05 00:00:00 | 19575 | 190
 |  | 201 | 2023-01-25 00:00:00 |  | Acc | JMS-007-22 | FO-555-22 |  |  |  | 650 | Fabric | 2023-01-28 00:00:00 | 2023-02-02 00:00:00 | 800000 | 195
 |  | 202 | 2023-01-26 00:00:00 |  | Acc | JMS-007-22 | FO-555-22 |  |  |  | 650 | Fabric | 2023-02-03 00:00:00 | 2023-02-08 00:00:00 | 800000 | 195
 |  |  |  |  |  |  |  |  |  |  | 655 | Fabric | 2023-02-09 00:00:00 | 2023-02-14 00:00:00 | 800000 | 195
 |  |  |  |  |  |  |  |  |  |  | 55 | Fabric | 2023-02-15 00:00:00 | 2023-02-20 00:00:00 | 80000 | 195
 |  |  |  |  |  |  |  |  |  |  | 620 | Fabric | 2023-01-28 00:00:00 | 2023-02-02 00:00:00 | 700000 | 196
 |  |  |  |  |  |  |  |  |  |  | 550 | Fabric | 2023-02-03 00:00:00 | 2023-02-08 00:00:00 | 540000 | 196
 |  |  |  |  |  |  |  |  |  |  | 150 | Fabric | 2023-01-28 00:00:00 | 2023-02-02 00:00:00 | 100000 | 197
 |  |  |  |  |  |  |  |  |  |  | 150 | Fabric | 2023-02-03 00:00:00 | 2023-02-08 00:00:00 | 100000 | 197
 |  |  |  |  |  |  |  |  |  |  | 150 | Fabric | 2023-02-09 00:00:00 | 2023-02-14 00:00:00 | 100000 | 197
 |  |  |  |  |  |  |  |  |  |  | 75 | Acc | 2022-02-01 00:00:00 | 2022-02-01 00:00:00 | 186000 | 198
 |  |  |  |  |  |  |  |  |  |  | 75 | Acc | 2022-02-01 00:00:00 | 2022-02-01 00:00:00 | 217000 | 199
 |  |  |  |  |  |  |  |  |  |  | 75 | Acc | 2022-02-01 00:00:00 | 2022-02-01 00:00:00 | 155000 | 200
 |  |  |  |  |  |  |  |  |  |  | 75 | Acc | 2022-02-01 00:00:00 | 2022-02-01 00:00:00 | 93000 | 201
 |  |  |  |  |  |  |  |  |  |  | 75 | Acc | 2022-02-01 00:00:00 | 2022-02-01 00:00:00 | 31000 | 202