How to Convert Columns of Text to Rows

1. Click the letter at the top of a column to select a column. Hold 'Ctrl' and click on more column headers to choose several columns.
2. Press 'Ctrl' and 'X' to cut the selected columns.
3. Right-click inside the first cell into which you want to paste the data as rows.
4. Select 'Paste Special' from the drop-down menu.
5. Select the 'Transpose' check box in the 'Paste Special' dialog box.
6. Click 'OK.' The columns will now appear as rows.