Transpose cells in Excel
To turn a column into a row or a row into a column, for example Page Headings, you can use the Transpose function.
To use Transpose
In this example a row of text is turned into a column.
Select the cells in the row to be transposed
Select the starting cell for your transposed list (not one of the selected cells)
Right mouse click, choose Paste Special
Choose Transpose and click OK.