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

Copy single column of values to an adjacent column- Excel 2007

We all know how to copy data in Excel, in fact there are many different ways to do it. In an effort to work smarter, not harder- copy data and eliminate a few clicks of the mouse by using the keyboard instead. 

1.  Select the column of data to be copied and the adjacent column. 

2.  Press Ctrl + Shift + . (period character), insuring both columns are highlighted prior.

Note: this trick also works with rows--> Press Ctrl + Shift + , (comma character)