Invert data order

[Guest]

I am trying to flip the data that i have in a column. I don't want them in
ascendent order or descendent order. I just want the bottom data to be at the
top and the top data to be at the bottom. Any suggestions? Thanks a lot.
Ibone

 

[Guest]

let's say we have data in A1 thru A30. In an un-used column enter:

=INDIRECT("A" & 31-ROW())

and copy down. Then take the helper column, copy it, and
paste/special/value back onto column A

 

[Guest]

=INDEX($A$2:$A$100,ROWS($A$2:$A$100)-ROWS($1:1)+1)

 

[Guest]

put in a helper column
enter 1,2 in the column to the end of the data
Select the two columns and sort on the helper column desending
delete the helper column