Changing Rows into Columns?

[TripletDad]

I have 4 values in a row that I need to change into columns in a different worksheet. My second worksheet is several hundred columns long and I can't even picture how to do it... any ideas?

I need the formulas to mimic the following:

='Cross & Step Main'!F2
='Cross & Step Main'!H2
='Cross & Step Main'!J2
='Cross & Step Main'!L2
='Cross & Step Main'!F3
='Cross & Step Main'!H3
='Cross & Step Main'!J3
='Cross & Step Main'!L3
='Cross & Step Main'!F4
='Cross & Step Main'!H4
='Cross & Step Main'!J4
='Cross & Step Main'!L4
='Cross & Step Main'!F5
='Cross & Step Main'!H5
='Cross & Step Main'!J5
... etc

Help?

 

[martindwilson]

=INDEX('cross & step main'!F:L,FLOOR(ROW(A8)/4,1),MOD(ROW(A4),4)*2+1)

 

[TripletDad]

Martin --

I don't know why it worked - but it did!!!

Thank you!!! Genius!!!

 

[TripletDad]

=INDEX('cross & step main'!F:L,FLOOR(ROW(A8)/4,1),MOD(ROW(A4),4)*2+1)

Martin - Sorry to bug - same question, different cells.

I need to mimic the following (the increase is a little different than the first example).

='Cross & Step Main'!Q2
='Cross & Step Main'!T2
='Cross & Step Main'!Q3
='Cross & Step Main'!T3
='Cross & Step Main'!Q4
='Cross & Step Main'!T4
='Cross & Step Main'!Q5
='Cross & Step Main'!T5
... etc

 

[Haseeb Avarakkan]

Hello, Try

A2, copy down.

=INDEX('Cross & Step Main'!$Q:$T,INT((ROWS(A$2:A2)-1)/2)+1,IF(MOD(ROWS(A$2:A2)-1,2),4,1))

 

[TripletDad]

Hello, Try

A2, copy down.

=INDEX('Cross & Step Main'!$Q:$T,INT((ROWS(A$2:A2)-1)/2)+1,IF(MOD(ROWS(A$2:A2)-1,2),4,1))

It worked!

Thanks!!! (I think my project is complete now!!!)

-Jeff

 

[TripletDad]

Thanks again!