Script Help !!!

[amit_saini]

Hi Folks,

I tried couple of options , but not able to get desired output.

See below table : Actual Value is "2188.00" against Unit_Short "g" , but not sure why this value is repeating for kg and mm also.

Right Output should be like below:

Please help!

Attached is sample application

Thanks,

AS

[sunny_talwar · Accepted solution]

I guess you need a better key which can differentiate between g, kg, & mm and there associated measured value