Hi, I have a program that exports all part numbers for a project, along with quantities, into excel. This program is basic, and if I have one part number called out 6 times, with 6 different quantities (or the same) it will put it into the spreadsheet 6 different times. Is there a way to sort, then combine each part number, so I only see each part number once, with the total quantity? I have a bit of programming experience, but none with excel, so if someone can just get me started in the right direction it would be much appreciated.

Thanks,
Alan