Quick question...combining columns of values

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.

On Mon, 26 Dec 2005 19:45:07 -0600, "Scot B" <[email protected]> wrote:

>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

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


"Scot B" wrote:

> 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.
>
>
>