Transpose-->switch columns and rows Excel 2007

The data is in rows or in columns and you want to rearrange or switch the data from one to the other.  Microsoft Excel 2007 provides a command to complete the process simply with just a few steps. 

To rearrange data from rows to columns, select the cells that contain the data. 

1.  From the Home tab, within the Clipboard group, click on Copy. (Ctrl +C)

2.  On the worksheet, select a cell  destination for the column into which you want to transpose the copied data. 

3.  From the Home tab, within the Clipboard group, click on the down arrow below Paste, and select Transpose. 

4.  Success!  Delete the data from the copy area. 

Additional Resource:
http://office.microsoft.com/en-us/excel-help/switch-transpose-columns-and-rows-HP010224502.aspx