combining information in multiple rows


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.
 
Ad

Advertisements

A

AlfD

Hi!

1. If your rows are consistently "out-of-step" by just 1 row, an eas
way would be to copy columns C,D & E from row 2 down: then paste i
back over the same columns from row 1 down.

2. I would use Data > Subtotals then display only the rows showin
subtotals: copy these visible cells and paste to another sheet. If yo
need more detail or help with tidying up the final sheet, come back.

3. NB Keep a secure backup.

Al
 

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