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,000 points
1,571 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,640 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,640 points
892 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,640 points
1,308 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
1,183 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,640 points
979 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,640 points
742 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,640 points
4,426 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,640 points
1,582 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,640 points
438 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