Flip a Column

[original.grace]

Is there an easy way to flip a column? For example, I have 96 rows of text. I want the text in A1 to be in A96, and the text in A96 to be in A1. And the text in A2 to be in A95, and the text in A95 in A2. And so on.

Thanks!

 

[T. Valko]

Is there an easy way to flip a column? For example, I have 96 rows of text. I want the text in A1 to be in A96, and the text in A96 to be in A1. And the text in A2 to be in A95, and the text in A95 in A2. And so on.

Thanks!

One way...

Enter this formula in B1 and copy down to B96:

=INDEX(A$1:A$96,ROWS(A1:A$96))

 

[original.grace]

Thank you so much!!!!

 

[T. Valko]

Thank you so much!!!!

You're welcome. Thanks for the feedback!

 

[VoG]

FWIW ASAP Utilities will do this in situ http://www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=55&utilities=42&lang=en_us

 

[Steve=True]

Great post T. Valko.

I have always just copied down a number range next to the data

i.e. 1-96

Then highlight numbers and data range.

Sort on numbers column Z-A

Steve=True
www.exceldashboardtemplates.com