Hi
in B1 enter
=OFFSET($A$100,-(ROW()-1),0)
and copy down

"LCC" wrote:

Hi! Everyone,

I have a column of numerical data entered in (say)
A1.A100. How can I reverse their order, i.e to have value
in A100 to be in B1, A99 in B2, ... and A1 in B100?

Appreciate any helps.