How do I combine quantities of similar line items

  • Thread starter Joshua Hullender
  • Start date
J

Joshua Hullender

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
 
D

Dave Peterson

I'd use data|Pivottable.

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

Peo Sjoblom

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