Thread: Flipping data
View Single Post
  #4  
Old September 24th, 2003, 07:59 PM
Biff
external usenet poster
 
Posts: n/a
Default Flipping data

Hi Mark,

Here's one way:

In B1 enter 1 and fill down as a series to B10. Select the
range A1:B10. Then sort on column B descending. Then you
can delete the number series in B1:B10.

Biff

-----Original Message-----
Is there a functional way to flip a column of data. So
that if I have 10 numbers in range A1:A10, the number in
cell A10 would then be at the top of the column, and the
number that was originally in A1 would be at the bottom.
.