Combining Duplicates

[woodymoe]

I have a sheet downloaded from a website. Column A is the product IDs. For some reason the site splits the data for some products into 2+ separate rows. I already formatted the duplicates and sorted them but I still need to combine all the data for each product into one row (sum). I need the data in a table so using subtotals or a pivot table wont work. How can I do this.

 

[SpillerBD]

There is a method using Get and Transform, though I might consolidate with a Pivot Table and then Copy/Paste Values.
Using Get and Transform (formerly PowerQuery) you would use a command GROUP BY. The Query Results are naturally returned to a Table.