Combining information from multiple rows

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top