If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Reverse Row Order?
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. |
#2
|
|||
|
|||
Reverse Row Order?
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. -- Wag more, bark less "trvlnmny" wrote: 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. . |
#3
|
|||
|
|||
Reverse Row 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 "trvlnmny" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|