Excel how to combine 2 columns with interleaved empty cells

Question

I have 2 columns: col1, col2 Both have interleaved data and empty cells like the image here-

How do I combine col1,2 contents to get col3.

I tried using If to find empty cells and not copy content when cell was empty, but the destination column was overwritten by blank cell.

Harun24HR Harun24HR · Accepted Answer · 2020-09-23T02:05:23

You can do it in different way. Try below formulas-

=A2&B2
=CONCATENATE(A2,B2)
=IF(ISBLANK(A2),B2,A2)