If you've started a spreadsheet and then realized it would make more sense to have the data organized in columns rather than rows (or rows rather than columns), you can use Excel's Transpose function to make it so.
Find out how to do it in Excel 2003, 2007 and 2010 at the illustrated step-by-step instructions at The How-To Geek.