Sometime you need to convert rows to column in excel. You can easily copy, or transpose, a row into a column and vice versa by using the transpose feature. To ensure you have room for new worksheet data, you can place the transposed columns or rows on a different worksheet or in a new workbook.
Click and drag to select the cells you want to transpose.
Note: Make sure a series of blank cells is available to accommodate the copied data.
Click the Home tab
Click the Copy button.
Click to select the first cell in the new column or row.
Note: Excel removes existing data by copying over it.
Click the Home tab.
Click Paste. A menu appears. Click Paste Transpose
The data appears in its new position.