Spreadsheet: 694244d1599474789-consolodating-date-power-query-product-report-analysis
Sheet: Prod-Admin

PRODUCTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CONSOLODATE PRODUCTS
 |  |  |  |  |  | Helper |  |  |  |  |  |  |  |  | I4-N300
 |  |  |  |  |  |  |  | PRODUCT | PID | AMOUNT | PRICE | TOTAL | CATEGORY TYPE |  | COPY | PID | AMOUNT | PRICE | TOTAL | COPY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BK10 | 7 | 25 | 775
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BK11 | 1 | 30 | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BK2 | 2 | 25 | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BK5 | 8 | 20 | 250
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BK6 | 3 | 25 | 175
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BK7 | 1 | 50 | 150
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BK8 | 1 | 25 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT1 | 5 | 60 | 300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT11 | 37 | 210 | 3610
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT12 | 6 | 90 | 540
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT13 | 16 | 110 | 1760
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT14 | 3 | 120 | 360
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT15 | 2 | 120 | 240
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT16 | 5 | 70 | 350
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT17 | 2 | 60 | 120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT18 | 3 | 60 | 180
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT19 | 2 | 70 | 140
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT20 | 3 | 80 | 240
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT3 | 28 | 70 | 1960
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT4 | 8 | 85 | 680
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT5 | 17 | 85 | 1445
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT6 | 9 | 100 | 900
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT8 | 1 | 110 | 110
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DKS1 | 59 | 120 | 2140
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DKS10 | 2 | 30 | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DKS2 | 1 | 80 | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DKS3 | 9 | 60 | 340
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DKS4 | 31 | 90 | 1560
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DKS5 | 6 | 60 | 240
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DKS6 | 10 | 90 | 330
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 4 | 90 | 180
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DKS9 | 9 | 90 | 480
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JB2 | 3 | 10 | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JS2 | 15 | 150 | 2250
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JS4 | 15 | 160 | 1140
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JS9 | 1 | 160 | 160
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KC-BEER-1 | 1 | 120 | 120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KC-BEER-3 | 1 | 140 | 140
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO1 | 24 | 45 | 5375
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MO2 | 2 | 50 | 425
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MS1 | 1 | 120 | 120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MS2 | 4 | 120 | 480
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MX10 | 8 | 100 | 800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MX11 | 13 | 100 | 1420
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MX13C2A | 3 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MX14 | 10 | 100 | 1015
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MX16 | 5 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MX16C | 5 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MX17 | 1 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MX18 | 23 | 100 | 2520
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MX19 | 9 | 100 | 900
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MX20 | 8 | 200 | 1600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MX21 | 2 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MX23 | 11 | 100 | 1125
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MX24 | 1 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MX27C1 | 1 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MX28 | 2 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MX29 | 3 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MX3 | 18 | 100 | 1955
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MX30 | 4 | 130 | 520
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MX4 | 12 | 100 | 1255
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MX5 | 4 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MX6 | 10 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OPEN1 | 9 | 373 | 433
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM1 | 7 | 60 | 420
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM2 | 1 | 70 | 70
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM5 | 12 | 60 | 720
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SD7b | 1 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SFS2 | 44 | 99 | 4356
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SFS3 | 21 | 99 | 1980
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SFS4 | 7 | 99 | 693
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SFS5 | 10 | 99 | 990
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SN-KC-1 | 4 | 79 | 316
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SN-KC-2 | 3 | 99 | 297
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SN-KC-3 | 4 | 120 | 480
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SN-KC-S2 | 3 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SN-KC-S3 | 4 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SN-KC-SC-C | 7 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XDEST1 | 1 | 20 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF1 | 27 | 199 | 5373
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF10 | 4 | 160 | 640
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF11 | 39 | 250 | 9950
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF12 | 9 | 250 | 2250
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF13 | 4 | 200 | 800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF14 | 5 | 600 | 1350
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF15 | 16 | 280 | 4545
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF16 | 6 | 150 | 900
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF17 | 5 | 150 | 790
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 27 | 590 | 6700
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 15 | 240 | 3600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF2 | 5 | 170 | 850
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 17 | 590 | 4520
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF21 | 19 | 240 | 4560
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF22 | 31 | 370 | 5530
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF23 | 15 | 210 | 3150
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF24 | 53 | 590 | 8395
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF25 | 53 | 150 | 8000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF26 | 21 | 170 | 3570
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF27 | 3 | 230 | 780
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF28 | 9 | 349 | 1874
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF29 | 9 | 170 | 1615
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF3 | 23 | 160 | 3695
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF30 | 4 | 240 | 960
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF31 | 11 | 170 | 1940
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF32 | 16 | 170 | 2800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF34 | 23 | 150 | 3185
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 23 | 220 | 6165
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2 | 300 | 685
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF37 | 36 | 99 | 3337
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF38 | 25 | 179 | 2456
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF39 | 83 | 99 | 7227
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF39b | 53 | 60 | 2940
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF4 | 26 | 180 | 4730
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF40 | 62 | 150 | 9300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF40b | 5 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 22 | 129 | 2838
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF41b | 5 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF42 | 15 | 80 | 1200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF43 | 1 | 120 | 120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 14 | 175 | 2450
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF45 | 2 | 200 | 400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF5 | 7 | 150 | 1140
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF6 | 5 | 129 | 645
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF7 | 98 | 710 | 16425
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF8 | 23 | 160 | 3695
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XF9 | 20 | 160 | 3200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 | 70 | 70
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XMFD2 | 7 | 70 | 260
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XMFD3 | 2 | 120 | 240
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XMFD5 | 2 | 130 | 130
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XMFD7 | 1 | 45 | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XMFD8 | 5 | 25 | 125
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XSD10 | 11 | 35 | 385
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XSD2 | 2 | 50 | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XSD3 | 14 | 65 | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XSD4 | 1 | 35 | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XSD5 | 8 | 35 | 140
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XSD6 | 4 | 65 | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 12 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XSD8 | 3 | 45 | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XSD9 | 9 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XTOP1 | 5 | 120 | 240
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XTOP12 | 1 | 15 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XTOP19 | 1 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XTOP22 | 4 | 80 | 95
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XTOP28 | 1 | 79 | 79
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XTOP29 | 1 | 120 | 120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XTOP7 | 1 | 15 | 15