Merge /Join data
 

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?

Merge /Join data
 

Hi Kevin. Take a look at the Subtotal function on the Data menu. First,
sort your table, product, customer. Then use subtotals - for each change in
product sum qty. Then, don't replace those subtotals, but do it again based
on customer. HTH
--
Sincerely, Michael Colvin


"Kevin R" wrote:

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?

Merge /Join data
 

this helps a ton......but i canot figure how to get these 17 rows to 3 rows
based on product with summed qty....?

AutoCAD 1 CONCRETE TECHNOLOGY
AutoCAD 1 CONCRETE TECHNOLOGY
AutoCAD 1 CONCRETE TECHNOLOGY
AutoCAD 3 CONCRETE TECHNOLOGY
AutoCAD 1 CONCRETE TECHNOLOGY
AutoCAD 5 CONCRETE TECHNOLOGY
AutoCAD 1 CONCRETE TECHNOLOGY
AutoCAD 1 CONCRETE TECHNOLOGY
AutoCAD 1 CONCRETE TECHNOLOGY
AutoCAD 1 CONCRETE TECHNOLOGY
AutoCAD 1 CONCRETE TECHNOLOGY
AutoCAD 1 CONCRETE TECHNOLOGY
AutoCAD 1 CONCRETE TECHNOLOGY
AutoCAD 1 CONCRETE TECHNOLOGY
AutoCAD LT 1 CONCRETE TECHNOLOGY
AutoCAD LT 13 CONCRETE TECHNOLOGY
AutoCAD Mechanical 1 CONCRETE TECHNOLOGY

"Michael" wrote:

Hi Kevin. Take a look at the Subtotal function on the Data menu. First,
sort your table, product, customer. Then use subtotals - for each change in
product sum qty. Then, don't replace those subtotals, but do it again based
on customer. HTH
--
Sincerely, Michael Colvin


"Kevin R" wrote:

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?