Hi

I all versions of Excel, provided you select the whole block of data first,
then the row data will remain intact as you perform a sort.

I guess your data is 63 columns wide, and up to 112 rows deep.
If you select all of this first, then DataSortchoose column
requiredchoose Ascending or DescendingOK

As you have Excel 2003, you could place your cursor in any cell of your data
and choose DataListCreate ListOK
If you don't have headers, the process will insert a new Row1 with headings
of Column1, Column2 etc.
The whole block of data will be enclosed within a blue line.
There will be dropdowns created on each header, and there are options to
Sort ascending or descending on each dropdown (in addition to options to
filter the data).
Choose whichever column you like and sort, and all the data will be sorted
by that column.
Much easier that having to go through the DataSort routine each time.

For safety's sake, work on a copy of your data, in case you make an error

--
Regards
Roger Govier

"sretepe" wrote in message
...
I have a table of data where each row represents data for a particular
year
and month. The problem is the the data for each day of the month is
included
in the row with alternating columns of date (day of month) and data (for
that
day). I want to be able to rearrange the table quickly so I can sort the
data without losing the day, month and year the data is associated with.
Any
helpful thoughts are appreciated. I'm working with Excel 2003.

Below is an pictoral example of how the table is currently organized
189701 1 0.0 2 0.1 3 0.5 4 0.0 5 3.1 6
3.4
.....
189702 1 1.1 3 2.1 3 0.0 5 1.4 5 5.1 7
1.8
.....

FYI 189701 = January 1897