Flipping Data in Excel

A

August

I need to flip a few rows of data. For instance, right now I have
colums that look like this:

1 6
2 7
3 8
4 9
5 10

I need them to look like this:

5 10
4 9
3 8
2 7
1 6

These columns have thousands of entries in them, so if there's a
function that can cover this for me it would save me a ton of time.
 
D

David Biddulph

If you don't have a column that's already sorted into order like your
examples are, then add a helper column with entries 1, 2, 3, etc to the end
of your data.
Select all your data (all the relevant rows and column). Data/ Sort/ sort
by whichever column has your increasing numbers/ Sort descending.
 
T

T. Valko

One way:

=INDEX(A$1:A$5,COUNTA(A$1:A$5)-(ROWS($1:1)-1))

copy across then down.

Biff
 
Top