I am using a datagrid control to display four types of data that represent quarterly financial data. The data is stored as four data types (columns) each with 40 fields (one for each quarter). For display purposes only I want to display this like it would appear in Excel; that is quarterly data across the top and four rows.

This data is not stored in a database but for now is hard-coded in a set of arrays in the code (eventually it'll be read from an XML file). The mechanism used to store the data shouldn't matter to how datagrid deals with it, right?

How can I get the datagrid to rotate the data when it's displayed? I want it like this:

DataA | Y1Q1 | Y1Q2 | Y1Q3 | Y1Q4 | Y2Q1 | ... etc
DataB | Y1Q1 | Y1Q2 | Y1Q3 | Y1Q4 | Y2Q1 | ... etc
DataC | Y1Q1 | Y1Q2 | Y1Q3 | Y1Q4 | Y2Q1 | ... etc
DataD | Y1Q1 | Y1Q2 | Y1Q3 | Y1Q4 | Y2Q1 | ... etc

I want all for in one datagrid, not four data grids (since this data set needs to stay in sync such that they scroll together as user enters data across the quarters).

Thnx, Deb