Columns of text in Excel can be converted into rows. You can do so manually but it would be a tedious process. Alternatively, you can use the Paste Special command to quickly change the columns of text into rows.
- Simply copy the text from your columns.
- Click inside the first cell of the destination row and click Paste Special.
- From the Paste Special dialog box, click Transpose.
- Click OK.
Excel moves the text into the rows, beginning with the first cell you selected in step 2.