You can easily reverse the order of the rows in a column, either in formula, or in a different cell, using:

=INDEX(B1:B6,ROWS(B1:B6)+1-ROW(B1:B6))

(In this case, the range to reverse is B1:B6.)

For use inside a formula, just drop the leading "=" and you're good to go. This will work with any version of Excel back to 2007 when it added the ROWS function. INDEX goes back to my early days with it in 1991, to the best of my recollection. If needed, there are substitutes for the use of ROWS, but they involve functions usually considered less desirable.

The reversed range has no limit on size that its source does not have. And it yields elements that are the same data type as their originals.