Skip to main content

How to change row to column in Excel?

Author: Tech Support Last Modified: 2013-05-27

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


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

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 300 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 300 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 > Transform Range, 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:

Best Office Productivity Tools

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

Description


Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Comments (3)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Thanks for sharing an information on excel. With above information you have shared Multiple Rows And Columns With Kutools For Excel. you can easily do a work in an easy manner. If you still facing an issue you can go for advance excel training course.
This comment was minimized by the moderator on the site
I have data in excel as : Place and Name is the Column name and it has its corresponding values.



Place Mumbai


Name Ram


Place Delhi


Name Harpreet


Place Kanpur


Name Tej





I want the above data as :



Place Name


Mumbai Ram


Delhi Harpreet


Kanpur Tej



Many Thanks for help.

Hetal.
This comment was minimized by the moderator on the site
I need the code in one column and Description in another Code & Description Unit CI0001NAT M White sleeving Type 2A W9680R CI0001RED M Red sleeving Type 2A W9685RRD CI0002RED M Sheathing TY-111 - Red #550 1000 CL001NAT M Dacron / Polyester 650 lbs CL002NAT M Dacron / Polyester 950 lbs CL007NAT M Dyneema / Spectra 725 lbs CL008NAT M Dyneema / Spectra 1000 lbs CL009NAT M Dyneema / Spectra 1500 lbs CL010ORG M Dyneema / Spectra 1000 lbs Orange CL011NAT M Cord / Rope 3948 CL014 M Technora / HMA 500 lbs CL015 M Technora / HMA 650 lbs
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations