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.

  1. Simply copy the text from your columns.
  2. Click inside the first cell of the destination row and click Paste Special.
  3. From the Paste Special dialog box, click Transpose.
  4. Click OK.

Excel moves the text into the rows, beginning with the first cell you selected in step 2.