How to replace data with other data in two columns without accounting empty cells

[Jyggalag]

Hi all,

I hope the title makes somewhat sense, but allow me to elaborate. I have a setup like this:

I want my numbers in column D to replace whatever value is in column B

However, if I mark all of column D and move it other to column B it will say the following:

If I say yes to this, I end up with this result:

How do I do this without deleting the values that are already in cell B1:B3, B6 and B8?

I realize that I can do this by individually moving each number in column D to replace the value in column B, but it would take forever

Thank you all!

Best regards,
Jyggalag

 

[steve the fish]

Use this in E1 and drag down. Then you can use those to paste over B1:B10.

=IF(D1<>"",D1,B1)

 

[Jyggalag]

Use this in E1 and drag down. Then you can use those to paste over B1:B10.

=IF(D1<>"",D1,B1)

This is a nice solution. I like it! Thank you very much Steve Have a nice day!