Reverse Row Order?

  • Thread starter Thread starter trvlnmny
  • Start date Start date
T

trvlnmny

I have a file where each row contains data about a geographic
location. The order they are in is south to north. I now have a need
to reverse the order. That is have them now list north to south.
Thanks for your help.
 
One easy way
Insert a column to the left of the data
input 1 in the first cell
input 2 in the second cell
input 3 in the third cell

copy this down so that the number continually increase

Sort the new column and the orginal data by the first column in descending
order.
 
Try this.

In the next column enter 1 and pull down to whatever, the end of the list.

Select both columns and sort Decending by the numbered column. Delete
numbered column.

HTH
Regards,
Howard
 
Back
Top