Reverse Row Order?

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

Brad

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

L. Howard Kittle

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top