Reversing data in columns

  • Thread starter Thread starter CT EA
  • Start date Start date
C

CT EA

I have several columns in a single spreadsheet that have a date (12/01/01 and
ascend to 12/31/09. There are also several rows of corresponding data
underneath each date. Is there a way to reverse this information using a
formula rather than cutting/pasting/moving?

Thanks in advance
 
1. pick an un-used column and enter:
=ROW() and copy down

2. copy the column and paste/special/values back onto the column

3. sort the worksheet by the new column DESCENDING

this will reverse all the rows.
 
Gary''s Student said:
1. pick an un-used column and enter:
=ROW() and copy down

2. copy the column and paste/special/values back onto the column

3. sort the worksheet by the new column DESCENDING

this will reverse all the rows.
Click to expand...

I thought about that also but wouldn't that put the date field BELOW the
data instead above it. Of course I'm assuming the following layout based
on the OP's description. You know what they say about assuming:-)

1 12/12/09
2 data1
3 data2
4 12/13/09
5 data3
6 data4

sorts to
6 data4
5 data3
4 12/13/09
3 data1
2 data2
1 12/21/09

gls858
 
Back
Top