i have a worksheet that has 17 rows with the following columns:
Customer, Product, Qty, and a few more....
In each of the 17 rows customer name is the same, but Product and Qty will
vary.
I would like create a macro or use some built in excel tool to Merege the 17
rows to 2 rows based on the Product Name and sum up the qty.

IN other words based on the Product column merge/join a selection set to a
single row for each customer, product, with QTY totaled?

any thoughts?