How to change row to column in Excel?

Sometimes, you may need to change rows to columns or vice versa in Excel. We are going to talk about the old tricks of how to convert or change rows to columns or vice versa in Excel.

Change a row to a column in Excel

Change multiple rows to multiple columns in Excel

Change a column to a row in Excel

Change multiple columns to multiple rows in Excel;

Change range or single row to column with Kutools for Excel

Change one column to multiple rows and columns

Change a row to a column in Excel

Say you have a row data in Excel as following screenshot need to be changed into a column in Excel.

Firstly, please select and copy the row, then select a cell where you want to paste the data and right click it, and choose to paste the data with Paste option Transpose command. It will change the row into a column like so:

You can quickly access Paste option Transpose command from the right click menu as:

Paste option Transpose command

Change multiple rows to multiple columns in Excel

Suppose you have multiple rows data in Excel as following screenshot need to be changed into multiple columns in Excel.

By using the Paste option Transpose command, you can easily change multiple rows into multiple columns like so:

Steps: 1. Select and copy multiple rows. 2. Select a cell you want to paste and right click it. 3. Using the Paste option Transpose command to paste.

Change a column to a row in Excel

If you want to change a column data into a row in Excel as following screenshot:

By using the Paste option Transpose command, you can easily change a column into a row like so:

Change multiple columns to multiple rows in Excel

To change multiple columns into multiple rows as following screenshot in Excel:

By using the Paste option Transpose command, you can easily change multiple columns into multiple rows like so:

Change one column to multiple rows and columns

To apply the above operations in Excel is quite easy by using the Paste option Transpose command. Nevertheless, if you want to change one column to multiple rows and columns in Excel, can you get it done with using the same Transpose command in Excel? For example:

To change one column data in Excel as following screenshot into multiple rows and columns:

You can easily process such operation in Excel with handy Excel add-ins software - Kutools for Excel - which includes more than 80 add-ins that to free you from time-consuming operation in Excel. Free to trial in 30 days without features limitation.

After installing Kutools for Excel, please select the column you want to change into multiple rows and columns, and click Kutools > Modify > Transform Vertical Range. See screenshot:

Specify the settings you need in Transform Vertical Range dialog box and click OK.

Kutools for Excel

More than 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.