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.

...
Convert columns to rows.

Step

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.

Step

Press "Ctrl" and "X" to cut the selected columns.

Step

Right-click inside the first cell into which you want to paste the data as rows.

Step

Select "Paste Special" from the drop-down menu.

Step

Select the "Transpose" check box in the "Paste Special" dialog box.

Step

Click "OK." The columns will now appear as rows.