title: Combine rows with duplicates and then remove row
body: <p>I've created an excel file that creates an order list for furniture. The list can be anywhere from 100 rows to 3000 rows long depending on the size of the order.</p>
  
  <p>My problem is that the data that creates the order list includes alot of duplicates as shown in the picture.</p>
  
  <p>What I would need help with is to create a macro that takes all matching id numbers and combine it into one row where the quantity is combined. The list price will be the same and the total price is a function taken from quantity*listprice.</p>
  
  <p><a href="https://i.stack.imgur.com/w6XOE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/w6XOE.png" alt="img1"></a></p>
  
  <p>I'm aware that there is several posts regarding problems like mine but i have not managed to find a sulution. I'm not that experienced with coding so would appreciate all help I can get!</p>