Data in two columns need to copy to single column

[santoshbhagade]

Hi,

I have data in two column which i need to get it in one column, could you please suggest me a formula, please find here the attached file to know the more details.

Thanks.

 

[bines53]

Hi santoshbhagade ,

Is that what you meant?

David

 

[John Jairo V]

Hi @santoshbhagade.

An option in the file. Blessings!

 

[Asheesh]

Hi,

Put the below formula in E4 as per your attached and drag it down…


INDEX($A$4:$B$8,INT((ROW($A1)-1)/2)+1,MOD(ROW($A1)-1,2)+1)

 

[santoshbhagade]

Hi David,

I just put a number from 1 to 10 for example what if there are text in the two columns ?

I need the data in single column in below format
lets assume there is data in column A and column B and i want the result in column C such as
C1 = A1
C2 = B1
C3 = A2
C4 = B2
C5 = A3
C6 = B3 and like wise till the data ends.

 

[Asheesh]

I was about to highlight that David’s solution will work only in case of numbers..however, solution provided by JJ or me will work fine..be it text or an integer

 

[John Jairo V]

Asheesh... David's solution (grettings David and Asheesh) work only with numbers if they are in the specific "zigzag" order, because the formula extract in ascendent order all the numbers in the range. Blessings!

 

[santoshbhagade]

thanks @John Jairo V and @Asheesh

thats works perfectly fine