Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rearrange data from columns to rows | Excel Discussion (Misc queries) | |||
Rearrange data in columns | Excel Discussion (Misc queries) | |||
Rearrange data into other columns | Excel Discussion (Misc queries) | |||
Help, please - How to rearrange 1 column of data into 4 columns ? | Excel Discussion (Misc queries) | |||
Rearrange two columns of data | Excel Discussion (Misc queries) |