I'm hoping someone is able to help as I am at a dead end.
I have a spreadsheet of 23,000 lines in two columns of data. Column A has data in every cell and Column B has data in a selection of cells, the others being blanks.
What I need to do is merge the data so those cells in colum B that hold data overwrite/update those in colum A, but the cells in column B that are blank don't overwrite the existing data in Column A
I am sure there's a formula pattern or an IF function but I just can't work it out.
Highlight the cells in column A and B, then press the F5 (GoTo) key, click on Special, then on Blanks and OK. Then begin to enter a formula by typing =, and then click on the cell immediately to the left of the active cell, and then do CTRL-Enter. All the blank cells in column B will be filled with the corresponding values from column A. You can then fix the values in column B so as to remove the formulae, and then you can delete column A.
Highlight the cells in column A and B, then press the F5 (GoTo) key, click on Special, then on Blanks and OK. Then begin to enter a formula by typing =, and then click on the cell immediately to the left of the active cell, and then do CTRL-Enter. All the blank cells in column B will be filled with the corresponding values from column A. You can then fix the values in column B so as to remove the formulae, and then you can delete column A.
Hope this helps.
Pete
Pete, That was just the job! Perfectly done in a few seconds, saving me hours of work. THANKS
Bookmarks