B
bakwan
1) I am trying to combine data which appears in multiple
rows into one row. For example, the product code and
description appear in cell A1 & B1 but the quantity,
product price and total appear in cell C2, D2 and E2. Is
there a quicker way to move the quantity, product price
and total into the same row as the product code and
description?
2) Some Products appears more than once with different
quantity.
For example:
Product A qty 5 price $1.50 total $7.50
Product A qty 3 price $1.50 total $4.50
I want this product to appear in one line with total
quantity of 8 , price $1.50 and Total $12.00
How do I do this?
Thanks.
rows into one row. For example, the product code and
description appear in cell A1 & B1 but the quantity,
product price and total appear in cell C2, D2 and E2. Is
there a quicker way to move the quantity, product price
and total into the same row as the product code and
description?
2) Some Products appears more than once with different
quantity.
For example:
Product A qty 5 price $1.50 total $7.50
Product A qty 3 price $1.50 total $4.50
I want this product to appear in one line with total
quantity of 8 , price $1.50 and Total $12.00
How do I do this?
Thanks.