Moving columns order
There is also a manual method that's not too time consuming if you only have
to do the column sort once or twice.
Temporarily add a row that will be the index for sorting your columns. For
example:
Col 1 Col 2 Col 3 Col 4 Col 5
apple pear orange grape kiwi
joe jim jan fred sheila
3 5 2 1 4 <---- This will be the sort index
Then select the columns you want to sort, and select "Data/Sort..." from the
menu.
Under "Options..." select "Sort left to right". Then select the inserted
row to sort by. The example will look like:
Col 4 Col 3 Col 1 Col 5 Col 2
grape orange apple kiwi pear
fred jan joe sheila jim
1 2 3 4 5
You can then delete the index row.
HTH,
Eric
|