RadGrid -- switch rows and columns

[manared]

I have a RadGrid and I want to bind it to a datasource, but I want to do it differently than normal. Normally, rows are added for every entry into a table in the database. But, I have a table with a bunch of expense items in it (This is a set amount of items and will not change or have items added by the users) and I want these items to be listed on the left side of the grid. Then I have another table that will list all the amounts for certain days for each expense, so each entry is one specific date. It will list each expense and show how much was spent for that particular expense for that specific date. This table could have as little as one date or as many as a month's worth of dates. I would like these entries to go in the columns in the grid. Is this possible at all? If not or if it's too difficult, I'll just switch them around and put the expenses on top in the columns, not a problem. The only reason I would want it the other way is to have detail tables for certain expenses, but if I can't do this, I will just put more grids on the page for all the details for each expense. Thank you very much and please let me know if more information is needed. Thanks!