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
• 28,900 points
171 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
• 53,520 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 2 days ago in Others by narikkadan
• 53,520 points
26 views
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
• 53,520 points
240 views
0 votes
1 answer
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
• 22,960 points
212 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
• 53,520 points
123 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
• 53,520 points
110 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
• 53,520 points
957 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
• 53,520 points
110 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 in Others by narikkadan
• 53,520 points
45 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