How to merge two cells in excel with same field name

Question

The two columns E and F had the same name (option 1 and choice 1), thus I was attempting to combine them into a single column by copying the data from cell col F into the empty cells of column E.

Answer 1

Insert 2 new columns, G & H.

Enter the formula In G2:

=IF(E2="",F2,E2)

For the rows where E and F contain values, duplicate this formula. The addresses for the cells will automatically change.

Copy all the cells in G and Paste Values into H. Now remove columns E, F & G.