Data Consolidation

Hello,

I am working with some spreadsheets that contain redundant information when I get them and I would like to find a way to make my life easier by finding a way to consolidate the data.

I have a UPC column - this is the column that contains redundancies. Looking at the attached example, I would like to combine the UPC and amount columns (without changing their values) and sum the quantities and totals columns.

I am not sure if there is a way to do this using the consolidate tool.

Thanks!