Thread: Changing the Direction of Data within a Column

This may sound simple, but have exhausted all means...perhaps not seeing the
solution for the "Trees". If I have...say 300 events in a column, numbers
range from 15.6 to 15.9 in any order and I want to reverse (not sort) that
column where the last event is the now the first, what do I need to make this
happen? Again, it is not sorting Ascend/Descend, it is changing the order
the events are displayed within the given column.

Any assistance would be greatly appreciated.

Michael R. Parsons
michael.parsons@wpafb.af.mil

Michael
Add a blank column to one side of that column. Fill that column from 1
to however many entries you have in the first column. Sort both columns
together, sorting on the column you just put in. Sort Descending. Delete
the helper column. HTH Otto
"Michael Parsons" <Michael Parsons@discussions.microsoft.com> wrote in
message news:FEA896AE-800E-4179-B56B-A4C04B52A0A7@microsoft.com...
> This may sound simple, but have exhausted all means...perhaps not seeing
> the
> solution for the "Trees". If I have...say 300 events in a column, numbers
> range from 15.6 to 15.9 in any order and I want to reverse (not sort) that
> column where the last event is the now the first, what do I need to make
> this
> happen? Again, it is not sorting Ascend/Descend, it is changing the order
> the events are displayed within the given column.
>
> Any assistance would be greatly appreciated.
>
> Michael R. Parsons
> michael.parsons@wpafb.af.mil