How to Copy Column Values to Rows in Excel 2007

1. Copy all of the blocks in the column that you want to convert to a row. You can copy multiple blocks at once by holding down the 'CTRL' button as you click on each block in the column.
2. Right click anywhere within the highlighted blocks and select 'Copy.' Another method for copying the information in the columns is to press the 'CTRL' and 'C' buttons at the same time.
3. Choose the row where you want to paste the information, right click on the first block and select 'Paste Special.' A menu with several options will pop up.
4. Place a mark next to 'Transpose' in the bottom right section of the menu and click 'OK.' The information in the column will paste into the row you chose.