title: Removing duplicates from Excel rows by adding values of some columns
body: <p>I have an Excel file containing 500 rows containing product details and their quantities in different programs. All these 500 rows are duplicated products with different quantities. I would like to remove duplicates and add up quantities so instead of 5 rows having productID D1 I want to have one row only (quantities of 4 other rows is added to the remaining row)
  [I am looking to create bottom table from top one]</p>
  
  <p><a href="https://i.stack.imgur.com/tfMmo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tfMmo.png" alt="enter image description here"></a>
  I found similar problem on stackoverflow and people suggested uploading the data in the database and have sum(quantity1), sum(quantity2),...but I have 150 columns so I would not be able to write a query for that. (<a href="https://stackoverflow.com/questions/53835645/removing-duplicate-rows-by-adding-column-value">Removing duplicate rows by adding column value</a>)</p>
  
  <p>I am thinking of writing a python script but I am not sure how I can handle the duplicates.</p>
  
  <p>Many Thanks.</p>