Combine identical lines to 1 with sum

Hi.

I have a location sheet with SKU - QTY - Location with 20.000+ lines, where the same SKU and Location can be multiple times. How can i do so they will become 1 line with a sum?

Thanks

use a pivot table is the easiest answer but QTY needs to the right column

SKU and Location as row
quantity as the value


Perhaps choose report layout as table and repeat all item labels
also remove subtotals

Hi Davsth

That was perfect, learned some more about Pivot tables today, thank you.

Always better to learn and no formulas involved!