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

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

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

Time：02-08

I have met some problem with merging two columns to one. I have some solution but not exactly fits to my problem (found here:

CodePudding user response：

If you want to stick to your formula, then you could modify it like this:

If you want to place it on a different sheet you just add the sheet name:

=INDEX(MySheet!$A$2:$D$9;ROUND(ROW(MySheet!A1)/2;0);IF(MOD(ROW()-ROW(MySheet!$A$2);2)=1;4;1))
=INDEX(MySheet!$A$2:$D$9;ROUND(ROW(MySheet!A1)/2;0);IF(MOD(ROW()-ROW(MySheet!$A$1);2)=1;4;1))

Page link：https//www.codepudding.com/Blockchain/292271.html

Prev:How do I use .Value to get cell value and search for another cell w same value?

Next:trigger macro when a formula cell gives two kind of text

Tags：

Links：
CodePudding