Hey folks, please help me

In this data product id and product name are repeating

ProductId ProductName Value
8404 Nimesulide 100 mg Tab 3.0000
8404 Nimesulide 100 mg Tab 3.0000
8404 Nimesulide 100 mg Tab 3.0000
8426 Cetrizine (5 mg/ 5 ml) Syrup 12.0000
8426 Cetrizine (5 mg/ 5 ml) Syrup 12.0000
8426 Cetrizine (5 mg/ 5 ml) Syrup 12.0000

I want to reduce the data, so that the output will be :

ProductId ProductName Price
8404 Nimesulide 100 mg Tab 9.0000
8426 Cetrizine (5 mg/ 5 ml) Syrup 36.0000