If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Reversing data in columns
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 |
#2
|
|||
|
|||
Reversing data in columns
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 - gsnu200859 "CT EA" wrote: 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 |
#3
|
|||
|
|||
Reversing data in columns
Gary''s Student wrote:
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. 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 |
Thread Tools | |
Display Modes | |
|
|