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, 2022 in Others by Kithuzzz
• 38,010 points
1,113 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, 2022 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
1 answer

Create a hyperlink to a sheet with same name as the value in the selected cell in Excel through VBA

Credit to Spectral Instance who found the ...READ MORE

answered Feb 6, 2023 in Others by narikkadan
• 63,420 points
535 views
0 votes
1 answer
0 votes
1 answer
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, 2022 in Others by narikkadan
• 63,420 points
784 views
0 votes
1 answer

Add .xll as AddIn to Excel

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

answered Feb 17, 2022 in Others by gaurav
• 23,260 points
890 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, 2022 in Others by narikkadan
• 63,420 points
557 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, 2022 in Others by narikkadan
• 63,420 points
365 views
0 votes
1 answer

Open SAP from Excel VBA

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

answered Sep 30, 2022 in Others by narikkadan
• 63,420 points
3,583 views
0 votes
1 answer

How do you populate a google sheets/excel column with cells from a column in another sheet in the same document?

You have two options on chronology: sheet-by-sheet =QUERY({Sheet1!X:Z; Sheet2!X:Z; ...READ MORE

answered Dec 19, 2022 in Others by narikkadan
• 63,420 points
1,100 views
0 votes
1 answer

How to link two excel sheet in same excel file

It would be best if you made ...READ MORE

answered Jan 29, 2023 in Others by narikkadan
• 63,420 points
257 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