F
Frank
How do I rearrange data by dates in reverse order?
Example: I'd like to change the order to 3/21/2010, 3/22/2010,
3/23/2010...etc.
Current order
Column
A B C D
3/24/2010 3/23/2010 3/22/2010 3/21/2010
5:00 5:00 5:00 5:00
LSR LSR LSR LSR
82.6 82.8 83 82.3
93.6 80.3 94 88
106.7 100.9 105.2 102.8
108.5 103.6 106.7 105.4
111 107.5 109 109.1
113.6 111.3 111.5 112.8
116.8 115.5 114.4 117.1
121.1 120.7 118.5 122.1
126.9 127.2 123.8 129
135.3 136.4 132 138.8
148.3 150.2 144.8 153.2
165.7 168.3 162.5 171.8
183.3 184.9 177.9 188.5
192.8 191.5 188.4 194.5
96.4 96.7 96.8 96.7
1 1 1 1
97.4 97.7 97.8 97.7
2.6 2.3 2.2 2.3
Thanks
Example: I'd like to change the order to 3/21/2010, 3/22/2010,
3/23/2010...etc.
Current order
Column
A B C D
3/24/2010 3/23/2010 3/22/2010 3/21/2010
5:00 5:00 5:00 5:00
LSR LSR LSR LSR
82.6 82.8 83 82.3
93.6 80.3 94 88
106.7 100.9 105.2 102.8
108.5 103.6 106.7 105.4
111 107.5 109 109.1
113.6 111.3 111.5 112.8
116.8 115.5 114.4 117.1
121.1 120.7 118.5 122.1
126.9 127.2 123.8 129
135.3 136.4 132 138.8
148.3 150.2 144.8 153.2
165.7 168.3 162.5 171.8
183.3 184.9 177.9 188.5
192.8 191.5 188.4 194.5
96.4 96.7 96.8 96.7
1 1 1 1
97.4 97.7 97.8 97.7
2.6 2.3 2.2 2.3
Thanks