How to Convert Columns of Text to Rows
If you fail to plan ahead to determine how to organize your spreadsheet, you may end up placing text in columns that you should instead have placed in rows. Regardless of whether you do something like this on purpose or you do it simply because you were careless, you can make changes to your Excel spreadsheet's settings to convert the columns of text to rows. No special Excel expertise is needed to complete this action.
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.
Press "Ctrl" and "X" to cut the selected columns.
Right-click inside the first cell into which you want to paste the data as rows.
Select "Paste Special" from the drop-down menu.
Select the "Transpose" check box in the "Paste Special" dialog box.
Click "OK." The columns will now appear as rows.