Combining Identical Cells While Totaling their Data

Hi Martin

I've just retracted the earlier answer I have and have a better solution for you which I found here: https://www.extendoffice.com/documents/excel/1268-excel-combine-duplicate-rows-and-sum.html

Let me contextualise it to your situation:

1. Highlight/Select the columns where you want the combined values to be (e.g. M, N, O, P).

2. Go to Data menu tab > look under Data Tools.

3. Click onto Consolidate.

4. Click onto the down arrow icon (to the left of Browse) and select columns A, B, C, D, press Enter.

5. Click onto the Add button.

6. Once this is added as a reference (should look like $A:$D), tick Left column.

7. Click OK. 

Your Part numbers and associated values should now be consolidated into one entry!

I've also attached the sample file.

Let me know how you go?

Cheers
Damien