Hi peoples, I have some data with the date/time opposite to te direction I would like, ie:
15/09/2009 23:50 0.6 245.9
15/09/2009 23:40 0.7 239.3
15/09/2009 23:30 0.7 241.4
15/09/2009 23:20 1.1 251.0
15/09/2009 23:10 0.8 250.2
15/09/2009 23:00 0.6 249.5
15/09/2009 22:50 2.0 251.4
15/09/2009 22:40 2.7 251.5
Surely there must be some easy way to invert/swap the rows, ie such that it is like:
15/09/2009 22:40 2.7 251.5
15/09/2009 22:50 2.0 251.4
15/09/2009 23:00 0.6 249.5
15/09/2009 23:10 0.8 250.2
etc..
Maybe some kind of matrix operation?? Any help much appreciated.
Regards
Ima
Sorry for wasting your time guys, im an idiot! I just figured a really simple way around this by just adding another numbered column, and using sort!! Stupid!
Bookmarks