How to merge two cells in excel with same field name

0 votes

How to merge the two columns  i.e col E and col F into a single column where the empty cells in col E is filled with the data present in the col F

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.

Oct 7 in Others by Kithuzzz
• 20,660 points
61 views

1 answer to this question.

0 votes

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.

answered Oct 7 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

answered Sep 25 in Others by narikkadan
• 37,660 points
72 views
0 votes
1 answer

Excel: How to merge two columns into one (from different sheets or separated columns)

This equation is completely adjustable. Your two ...READ MORE

answered Oct 7 in Others by narikkadan
• 37,660 points
80 views
0 votes
1 answer

In Excel, how to find a average from selected cells

If one has the dynamic array formula ...READ MORE

answered Oct 9 in Others by narikkadan
• 37,660 points
67 views
0 votes
1 answer

Add .xll as AddIn to Excel

Hi, for adding an xll as Addln ...READ MORE

answered Feb 17 in Others by gaurav
• 22,040 points
134 views
0 votes
1 answer

Excel automatically converting 7 digit CAS number to another number (date?)

Looks like you could use: The formula in D2: =SUBSTITUTE(F ...READ MORE

answered Sep 25 in Others by narikkadan
• 37,660 points
64 views
0 votes
1 answer

JavaScript API does not work for Excel 2013?

Each method in the Office.js APIs is ...READ MORE

answered Sep 26 in Others by narikkadan
• 37,660 points
55 views
0 votes
1 answer

Open SAP from Excel VBA

It just means that there is no ...READ MORE

answered Sep 30 in Others by narikkadan
• 37,660 points
498 views
0 votes
1 answer

How to print an Excel Sheet using VBA with Nitro PDF Creator in Excel 2016

you can use the built-in excel facilities ...READ MORE

answered Sep 24 in Others by narikkadan
• 37,660 points
131 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP