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 with Kutools for Excel

Kutools for Excel: add 120 new features in Excel. Save one hour every day.
Classic Menu for Office: brings back classic menus to Office 2010 and 2013 (includes Office 365).
Office Tab: brings tabbed interface to Office as the use of web browser Chrome, Firefox and Internet Explorer.

arrow blue right bubble Change a row to a column in Excel

Hot
Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!

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

doc-change-row-column-2

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


arrow blue right bubble 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.


arrow blue right bubble 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:

Steps:

1. Select and Copy the column.

2. Select a cell you want to paste and right click it.

3. Using Paste option Transpose command to paste.


arrow blue right bubble 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:

Steps:

1. Select and copy multiple columns;

2. Select a cell you want to paste and right click it.

3. Using Paste option Transpose command to paste.


arrow blue right bubble Change range or single row to column with Kutools for Excel

If you install Kutools for Excel, you can quickly change the selected range or single row to columns by the feature of Transform Range.

Kutools for Excel: with more than 120 handy Excel add-ins, free to try with no limitation in 30 days. Get it Now

Here we take the following screenshot for example to change the single row to columns

doc-change-row-column-13

Please apply this utility by clicking Kutools > Range Converter > Transform Range, see screenshot:

Step 1. Select a single row you want to change to column, and click Kutools > Range Converter > Transform Range, or you also can select the single row from in the popup dialog.

Step 2. Check Single row to range in the popup dialog, and specify the Fixed value then click Ok. See screenshot: (Note: specifying the fixed value is to specify the number of the data in each column.)

Step 3. After clicking Ok, another popup dialog will be displayed, and select a cell that you want to output the result then click Ok, see screenshot:

You will see the single row change to column as shown as below:

doc-arrow-right

If you want to change a range to a single column as shown as below, please follow the below steps:

Step 1. Select a range you want to change to a single column, and click Kutools > Range Converter > Transform Range, or you also can select the range from in the popup dialog.

Step 2. Check Range to single column in the popup dialog, then click Ok.

Step 3. After clicking Ok, another popup dialog will be displayed, and select a cell that you want to output the result then click Ok.

You will see the range change to a single column as shown as below:


arrow blue right bubble Change one column to multiple rows and columns with Kutools for Excel

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:

Kutools for Excel: with more than 120 handy Excel add-ins, free to try with no limitation in 30 days. Get it Now

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.

Step 1. Select a single column you want to change to multiple rows and columns, and click Kutools > Range Converter > TransformRange, or you also can select the single column from in the popup dialog.

Step 2. Check Single column to range in the popup dialog, and specify the Fixed value then click Ok. (Note: specifying the fixed value is to specify the number of the data in each row here.)

Step 3. After clicking Ok, another popup dialog will be displayed, and select a cell that you want to output the result then click Ok.

Note: If you want to delimit the data by blank cell in the single column, you can check Blank cell delimist records. See screenshot:


Kutools for Excel

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

screen shot

btn read more     btn download     btn purchase

Add comment


Security code
Refresh