Okay so I'm hoping someone can help me.

I have a looooong (about 180 000 rows) list of part numbers, descriptions, prices and quantities. There are many duplicate part numbers. I need to go through and find the duplicates, add all their quantities into one cell and delete the remaining duplicates. I have used conditional formatting to find the duplicates easier but cannot use the remove duplicates button as it will delete the whole row and I need the quantity information in each row.

Does anyone have any ideas on a formula or macro I can set up to search the part number column (F) for duplicates and add the figures in the quantity column (J) and THEN delete the duplicate part number rows?

Maybe I need to put the new combined information in another sheet?

Technically I am an advanced user of Excel but have been out of the game for a bit so am a bit rusty so please explain as simply as possible

Many thanks in advance guys, hopefully I can find a solution or I'm going to have many many days of manually going through the whole lot.