How can I invert a column's contents

[Guest]

I have several columns of data and the data is listed upside down. SO, I
want to change it so the last line is first and the first line is last and
all the lines/rows in between are inverted as well. I know there's a simple
way to do this in excel but I don't know how.

 

[Guest]

As a work around until someone tells you the "proper" way to do this:

How about temporarily adding a column, inserting numbers 1 - 10 (or whatever
number of rows you wish to sort), sort in reverse numerical order and then
delete the extra column?

 

[RagDyeR]

One way ... using a formula:

=INDEX($A$1:$A$20,20-(ROW(A1)-1))

And copy down.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I have several columns of data and the data is listed upside down. SO, I
want to change it so the last line is first and the first line is last and
all the lines/rows in between are inverted as well. I know there's a simple
way to do this in excel but I don't know how.