Need help tedious work...

[Soth]

Hi-

A B C
Total $10
Total $10
Total 20
Total 20
Total $30
Total $40

I'm doing the tedious work by cut and paste the amounts from column C to
Column B. I have thousands of lines. Is there a quickest way to achive this?

My results:
A B C
Total $10
Total $10
Total $20
Total $20
Total $30
Total $40

Thanks

 

[Nuzza]

There's actually a few ways to achieve this. So the easiest, assuming that
each row will only have a value in either column B or C, then simply use a
sum function in column D. If some rows have values in both column B and C,
then you may need to use an if statement in column D.

 

[Gord Dibben]

Select column B

F5>Special>Blanks>OK

Edit>Delete>Shift cells left.


Gord Dibben MS Excel MVP

 

[Soth]

Nuzza, yes some rows have values in both column B and C, and how do I write
if statement?

Thanks

 

[Ashish Mathur]

Hi,

Select column B and press Ctrl+G > Special > Blanks > OK. This will select
all the blank cells. Now press the right arrow key and press Ctrl+Enter

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com