Thanks Its working... but in my data number of medicine IDs varies from 1 to 15 and have same number of Medicine Weights. How to use this formula for such cases ???

Example Data:-

Medicine ID Medicine weight
1326| 323| 1442| 500mg|2mg|60mg
1321| 320| 2447| 1442 125mg|2mg|60mg|30mg
100 500mg