B
Bakwan
I am trying to combine information from multiple rows into
one row.
For example:
Cell A1 is Product Code, Cell B1 is Product Description
and C2, D2, and E2 contains Product Quantity, Price and
Total Value.
Is there a quicker way to combine all this infomation into
one row?
I also have problem when one product appears more than one
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 to combine this so only one line of product A
appear with total quantity of 8, price still $1.50 and
Total $12.00. How do I do this?
one row.
For example:
Cell A1 is Product Code, Cell B1 is Product Description
and C2, D2, and E2 contains Product Quantity, Price and
Total Value.
Is there a quicker way to combine all this infomation into
one row?
I also have problem when one product appears more than one
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 to combine this so only one line of product A
appear with total quantity of 8, price still $1.50 and
Total $12.00. How do I do this?