How do I combine quantities of similar line items
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
|