I have some products in kilogram and some product as packet in a same single column
but i know i have 25 packeted product and they are 200 gram each
now I need help how I can calculate these 25 packeted product to convert them from 200 gram to kilogram and keep them to products that are already in kilogram a same single column
so requirement are,
1) convert packed product 200 gm to kilogram
2) and keep packetd product in same column with previously product that are already in kilogram
1) As you see in one column Product name (in KG, Gram, Pack and piece)
2) Quantity column is in kilogram (i.e. Beef Back Leg 2 kilo, 1.635 kilo)
3) Quantity column also has Pack and piece that are written 1 or 2 or so on
(i.e. 12 Pcs Brown Egg Pack- 1 or BBQ Sauce 510gm- 1)
3) here some Product name that are Pack and piece are in 200 gram like 12 Pcs Brown Egg Pack- 1 but in quantity it shows 1 or 2
now I need help how I can calculate these products (12 Pcs Brown Egg Pack- 1 or BBQ Sauce 510gm- 1) to convert them to kilogram and keep them to products that are already in kilogram a same single column
