rearrange the data in columns by dates?
 

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

rearrange the data in columns by dates?
 

Unless I'm missing something, sort by COLUMNS

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Frank" wrote in message
...
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