Quick question...combining columns of values

[Scot B]

Greetings, Experts,

Thank you for reading this message. I'm having a hard time combining data
from multiple columns into one list.

I have about 2,000 different values in each column. I'd like to create a
new column, say Column E, that has the following...

cell E1 would have the value of A1
E2=B1, E3=C1, E4=D1, E5=A2, E6=B2, E7=C2, E8=D2, E9=A3.......

This seems like it would be simple but I can't figure it out.

Thanks for your help!!!!!!

Cheers,

Scot B.

 

[Ron Rosenfeld]

Greetings, Experts,

Thank you for reading this message. I'm having a hard time combining data
from multiple columns into one list.

I have about 2,000 different values in each column. I'd like to create a
new column, say Column E, that has the following...

cell E1 would have the value of A1
E2=B1, E3=C1, E4=D1, E5=A2, E6=B2, E7=C2, E8=D2, E9=A3.......

This seems like it would be simple but I can't figure it out.

Thanks for your help!!!!!!

Cheers,

Scot B.

E1: =INDIRECT(ADDRESS(INT((ROW()-1)/4)+1,MOD(ROW()-1,4)+1))

Copy/drag down as far as needed -- ie to about E8000



--ron

 

[Ron Coderre]

Try this:
=INDEX($A$1:$D$2000,INT((ROW(E1)-1)/4)+1,MOD(ROW(E1)-1,4)+1)

Adjust range references to suit your situation.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro