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.


