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