Re-ordering question

[roscoe]

I have data that looks like this:

a ... x
b ... y
c ... z

Where values a-c are in column B and x-z are in column T

I need to copy them to another sheet that looks like this:

a
b
c
z
y
x

(Notice the reversing of the order of the Column T values)

The number of rows used in each column will always equal each other, but that number is arbitrary. I'm looking for a formula construct that will be copy the values from column B, know when it is exhausted, then start back up from the bottom of Column T.

Ideas?

Thanks!

I have no idea of even how

 

[mikerickson]

How about
=IF(ROW(A1)<=COUNTA(B:B), INDEX(B:B,ROW(A11),1), INDEX(T:T,2*COUNTA(B:B)-ROW(A1)+1,1))

 

[roscoe]

I'll give that a try at work tomorrow. Never would have come up with anything that elegant...

 

[roscoe]

How about
=IF(ROW(A1)<=COUNTA(B:B), INDEX(B:B,ROW(A11),1), INDEX(T:T,2*COUNTA(B:B)-ROW(A1)+1,1))

I'm confused about the A11 reference...

 

[mikerickson]

The A11 should be an A1.

The A1 is just to start the counting with 1.

 

[roscoe]

That's what I figured...thanks