Merging two columns; only overwriting blank cells

[ryan.maughan]

I have a project I am working on for work. It involves 3 columns: Column A is the person's name, Column B is the computer name of the user submitted by the user, and Column C is the computer name of the user as provided from a report. Some users left Column B blank so we ran the report in Column C to try to fill in the blank cells. I need to merge columns B and C. I want to merge the columns so that column C is the "master" column and column B only fills in the blank cells of column C.

I have read through about a dozen posts about merging columns but I could not find one where one column is a "master" column that is not overwritten unless there are blank cells.

Any help would be greatly appreciated.

 

[taigovinda]

Yes, there are various options within Paste Special (formulas, formats, cell width, etc.) and within Goto Special (blanks, formulas, constants, etc.) that can be very handy. Cheers!

 

[simsketch]

Yes, there are various options within Paste Special (formulas, formats, cell width, etc.) and within Goto Special (blanks, formulas, constants, etc.) that can be very handy. Cheers!

I signed up for mrexcel just so I could say thank you. Thanks tai...your handy trick to merge 2 columns with some empty cells in one saved me from hours of torture!