Increasing number or columns

Is there any way to increase the number of available columns? I need 400+ columns to set up a table the way I want it, but my available columns end at IV, is there anything I can do to change this. There seem to be many many times more rows, and I could just transpose the whole table, but it looses a little bit of its effect this way. Is there any way to sort of flip the layout of the entire sheet? I only need 100 or so rows.

Thanks in advance

Is there any way to increase the number of available columns?

Yes. Get Excel 2007. You'll get a thousand columns.

Is there any way to sort of flip the layout of the entire sheet?

Only using the Copy / Paste / Transpose or a VBA solution.