I have a list of data consisting of part#'s, vendor, qty, etc...

I would like to total the qty for each part#, and then delete all the other
lines so I have a collapsed list; where each part# is listed once, with the
total.

The subtotal function gives me the totals I need but then gets in the way
for other data manipultion needs.

Is there a way to SUM the Qty column for rows w/ the same Part# then delete
all the rows where the Part# is duplicated?