Spreadsheet: 860311d1708449295-help-on-data-cleaning-with-power-query-coochbehar-jan_24-stock-compailation
Sheet: ABM

PRODUCTS WISE  FORMAT  ( ALKEM ALPHA ) |  |  |  |  |  |  | OPENING/SECONDARY/CLOSING
Name:-
Desg :- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
HQ  :-
PROD NAME | PROD CODE | PRODUCTS | PTS | 1 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  | 11 |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  | 13 |  |  |  |  |  |  |  | 14 |  |  |  |  |  |  |  | 15 |  |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  | 17 |  |  |  |  |  |  |  | 18 |  |  |  |  |  |  |  | 19 |  |  |  |  |  |  |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ABM TOTAL
 |  |  |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Opening |  | Secondary |  | Transit |  | Closing |  | Primary
 |  |  |  | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY | VAL | QTY
 |  | Grand Total  ( A + B )
 |  | A TO Z NS SYRUP (100ML) | 54.92
 |  | A TO Z NS SYRUP (200ML) | 107.39
 |  | A TO Z DROPS (15ML) | 39.36
 |  | A TO Z NS PLUS TABLET | 86.03
 |  | A TO Z WOMAN CAPSULES (15'S) | 201.36
 |  | A TO Z IMMUNE TABLET (16'S) | 131.8
 |  | ALEVO- 250 TABLETS (10S) | 30.96
 |  | ALEVO- 500  TABLETS  (10S) | 57.74
 |  | ALEVO 750 [NAME] (10S) | 79.92
 |  | AMITAX 100 MG INJECTION  [ 2ML ] | 20.57
 |  | AMITAX 250 MG INJECTION  [ 2 ML ] | 34.63
 |  | AMITAX 500 MG INJECTION  [ 2 ML ] | 81.6
 |  | MEROSURE-O TABLETS (6'S) | 543.21
 |  | [NAME] -O ER 300 TABLETS (6'S) | 793.93
 |  | MEROSURE O DRY SYRUP (60 ML) | 302.14
 |  | NEW SORBACID LIQUID (200Ml) | 68.79
 |  | NOWORM SUSPENSION  [ 10ML ] | 12.72
 |  | NOWORM TABLETS 400 MG  [ 1S ] | 6.13
 |  | PRULASTIN-M TABLET | 110.57
 |  | PRULASTIN 20 MG TABLET | 85.5
 |  | PRULASTIN 40 MG TABLET | 128.57
 |  | PRULASTIN-M SYRUP | 80.36
 |  | SWICH 100 MG DRY SYRUP (30ML) | 122.14
 |  | SWICH 100 MG DT TABLETS  (10S) | 102.21
 |  | SWICH- 50  DT TABLETS (10S) | 76.5
 |  | SWICH 50 MG DRY SYRUP (30 ML) | 67.5
 |  | SWICH DROPS 25MG/ML (10ML) | 51.43
 |  | SWICH-200 [NAME] TABLETS (10S) | 122.14
 |  | SWICH-O TABLETS (10'S) | 180
 |  | SWICH-CV 100 MG DRY SYRUP (30 ML) | 134.36
 |  | SWICH-CV 325 [NAME] (10S) | 237.86
 |  | SWICH-CV 50 DRY SYRUP (30ML) | 84.86
 |  | SWICH-SR 200 MG TABLET | 77.14
 |  | SWICH-SR 400 MG TABLET | 113.14
 |  | SWICH-XP 1000 MG (VAILS) | 135
 |  | SWICH-XP 125MG  (VIAL) | 34.07
 |  | SWICH-XP 250 MG (VIAL) | 57.54
 |  | SWICH-XP 500 MG (VAILS) | 77.79
New Products If Any |  | TRUMP A | 70.71
 |  | TRUMP D | 70.71
 |  | MEROSURE O DS 30 ML | 160
 |  | [NAME] | 137