N
Neil Greenough
I have a .csv spreadsheet that contains the following details in the columns
A,B and C
-2.07762
53.5114
GATSO:6354@30
-2.74783
53.3244
GATSO:3746@60
-0.76298
51.98999
GATSO:5244@30
-0.24594
52.58497
GATSO:0890@30
-2.77217
55.74874
GATSO:3110@60
-0.32181
51.33441
GATSO:4834@40
-0.39686
52.57074
GATSO:5951@70
There are over 3000 rows in my spreadsheet. What I would like is to sort the
rows according to the data in the final column. So, I would like it so that
it sorts all those that end in ....@30 first, then .....@40 second etc
etc...............
Any ideas?
A,B and C
-2.07762
53.5114
GATSO:6354@30
-2.74783
53.3244
GATSO:3746@60
-0.76298
51.98999
GATSO:5244@30
-0.24594
52.58497
GATSO:0890@30
-2.77217
55.74874
GATSO:3110@60
-0.32181
51.33441
GATSO:4834@40
-0.39686
52.57074
GATSO:5951@70
There are over 3000 rows in my spreadsheet. What I would like is to sort the
rows according to the data in the final column. So, I would like it so that
it sorts all those that end in ....@30 first, then .....@40 second etc
etc...............
Any ideas?