Copying data from one column and pasting it only to the blank cells in another column

[mcgrawj]

Hello,

I am currently working with a spreadsheet in which I am trying to consolidate two different sets of data. Specifically, I have two columns of addresses that are sometimes the same and sometimes different (all of the rows correspond). I want to copy the addresses from the first column and paste them to the second column BUT I only want that information to go in the cells that are blank. In other words, I do not want to lose the existing data in the second column. Because I have over 1000 addresses to work with, I cannot afford the time to do this manually. Can someone help me figure out a way to do this? In your explanation, please try to use the most basic excel language possible because I am new to the program. Also, if you use a formula, can you explain each part of it? Thanks!

 

[RoryA]

Hi, and welcome to the forum.

Select your second column of data (with the blanks in it) and press f5 then click the Special button, choose Blanks from the options and press OK. This will select just the blank cells. Now type an = sign then press the left arrow and then press Ctrl+Enter. This will fill all blank cells with the contents of the cells to the left of them.

If you need the values to remain static after that, copy the whole of the second column and paste special - values.

 

[mcgrawj]

Hi,

Thanks for the information. Do I need to do something different if the columns are not next to one another? Thanks!

 

[mcgrawj]

Nevermind. I see that you just bring the arrow to whatever column you need (no matter if it's not directly next to the other column) and it works perfectly. Thank you SO much! That was tremendously helpful.