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.
Thanks in advance for any help!