trying to combine columns in excel

[abraun3]

Hi, I am trying to combine 4 columns in excel
I want the end result to be in one column as follows
a1
b1
c1
d1
a2
b2
c2
d2
a3
b3
c3
d3
and so on. Any help would be much appreciated. Thank you.

[Cutter]

Hello abraun3, and welcome to the forum.

One way would be:

In E2 or wherever else: =INDEX(A:D,CEILING(ROW(A1)/4,1),MOD(ROW(A1)-1,4)+1)

[Kyle123]

If you would like a vba alternative, something like:

Please Login or Register  to view this content.