Need for the data to be in Chronological Order

[sttombiz]

I have a set of data which is set up in rows. The data needs to be in chronological order by row so the columns sync up to create a graph of the data. Is there a way to do this without going row by row (ie is there a way to sort by row than by column for multiple rows). Here is how my data is currently set up:

Again, I want my first column for each data set to start with 12/31/2003. Thank you.

<table x:str="" style="border-collapse: collapse;" width="424" border="0" cellpadding="0" cellspacing="0" height="270"><col style="width: 96pt;" width="128"> <col style="width: 53pt;" span="3" width="71"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 96pt;" width="128" height="17">ABC UN Equity</td> <td style="width: 53pt;" width="71">
</td> <td style="width: 53pt;" width="71">
</td> <td style="width: 53pt;" width="71">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Date</td> <td class="xl24" x:num="39721" align="right">9/30/2008</td> <td class="xl24" x:num="37986" align="right">12/31/2003</td> <td class="xl24" x:num="38077" align="right">3/31/2004</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">ALTMAN_Z_SCORE</td> <td x:num="8.1159999999999997" align="right">8.116</td> <td x:num="6.9669999999999996" align="right">6.967</td> <td x:num="6.6595000000000004" align="right">6.6595</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">ABT UN Equity</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Date</td> <td class="xl24" x:num="37986" align="right">12/31/2003</td> <td class="xl24" x:num="38077" align="right">3/31/2004</td> <td class="xl24" x:num="38168" align="right">6/30/2004</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">ALTMAN_Z_SCORE</td> <td x:num="6.0593000000000004" align="right">6.0593</td> <td x:num="5.2972999999999999" align="right">5.2973</td> <td x:num="5.4029999999999996" align="right">5.403</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">ACS UN Equity</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Date</td> <td class="xl24" x:num="39721" align="right">9/30/2008</td> <td class="xl24" x:num="37986" align="right">12/31/2003</td> <td class="xl24" x:num="38077" align="right">3/31/2004</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">ALTMAN_Z_SCORE</td> <td x:num="4.0312000000000001" align="right">4.0312</td> <td x:num="7.9431000000000003" align="right">7.9431</td> <td x:num="8.9944000000000006" align="right">8.9944</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">ADBE UW Equity</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Date</td> <td class="xl24" x:num="37986" align="right">12/31/2003</td> <td class="xl24" x:num="38077" align="right">3/31/2004</td> <td class="xl24" x:num="38168" align="right">6/30/2004</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">ALTMAN_Z_SCORE</td> <td x:num="15.698700000000001" align="right">15.6987</td> <td x:num="13.9107" align="right">13.9107</td> <td x:num="16.904800000000002" align="right">16.9048</td> </tr> </tbody></table>

 

[lenze]

I'm not sure your data is Excel Friendly enough to do this. I know it probably looks good and is easy to read, but IMO, it would be better to have a data table with 3 columns
Company
Date
Score
There is a reason Excel gives you 65,536(1,000,000+ in 2007) Rows and only 256(16000+in 2007)Columns

Now you can create your Charts using a Pivot Table. Very easy
lenze