How to convert rows to columns in excel

How to convert rows to columns in excel

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.

Convert rows to columns

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

transpose in excel

The data appears in its new position.

transpose rows to column
Share:

This Post Has One Comment

  1. Yasmin

    Nice poste

Leave a Reply