How do I combine quantities of similar line items

[Guest]

I need a way to combine quantities of similar part numbers into one line item
rather than several line items of only a single quantity.

I would like to turn this......:
Part Number Qty.
D4DP91SRAA 1
D4DP6XY6AB 1
D4DP6XY6AB 1
D4DP6XY6AB 1
D4DP6XY6AB 1

........Into this:
Part Number Qty.
D4DP91SRAA 1
D4DP6XY6AB 4

 

[Dave Peterson]

I'd use data|Pivottable.

But if your data is sorted, using data|subtotals will get you kind of close.

 

[Peo Sjoblom]

Look at data>filter>advanced filter, select the part number range and select
unique records only and copy to another location