Flipping Data in Excel
 

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.

Flipping Data in Excel
 

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.
--
David Biddulph

"August" wrote in message
oups.com...
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.

Flipping Data in Excel
 

Data Sort Sort by: select Descending

"August" wrote:

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.

Flipping Data in Excel
 

One way:

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

copy across then down.

Biff

"August" wrote in message
oups.com...
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.