How to move data from column(s) to row(s) or vice versa in Excel?
Excel provides several ways to convert data from columns to rows or from rows to columns. You can use the built-in Paste Special command for a basic transpose, the Transform Range feature in Kutools for Excel for more flexible range conversions, or Transpose Table Dimensions to switch between cross tables and list tables.
- Move data from column(s) to row(s) or vice versa with Paste Transpose
- Move data from column(s) to row(s) or vice versa with Transform Range
- Transpose a cross table to a list table or vice versa with Transpose Table Dimensions
- Frequently Asked Questions
| Method | Best for | Conversion options |
|---|---|---|
| Paste Transpose | Quickly switching a simple range between rows and columns | Transposes the entire copied range |
| Transform Range | Converting one row or column into one or multiple rows or columns | Supports several transform types and a specified number of rows per record |
| Transpose Table Dimensions | Restructuring cross tables and list tables | Converts a cross table to a list table or a list table to a cross table |
Move data from column(s) to row(s) or vice versa with Paste Transpose
For a simple range, Excel’s built-in Paste Special command can quickly switch the orientation of the copied data.
- Select the column or columns you want to convert, and press Ctrl + C to copy the selection.
- Select the first cell where you want to place the converted data.
- Right-click the cell, and then click Paste Special > Transpose.
📝 Note:
This method creates a transposed copy of the source data. If you want to move rather than copy the data, delete the original range after confirming that the result is correct.
Move data from column(s) to row(s) or vice versa with Transform Range
The Transform Range feature in Kutools for Excel provides more conversion options than Paste Transpose. It can convert a single column into one row or multiple rows, or convert a single row into one column or multiple columns.
After installing Kutools for Excel, follow these steps:
- Select the data you want to convert, and then click Kutools > Range > Transform Range.
- In the Transform Range dialog box, select the required Transform type. If you want to convert a single column or row into a range, also specify the Rows per record.
- Click OK, and then select the first cell where you want to place the converted data.
- Click OK. The converted data is placed in the selected location.
Transpose a cross table to a list table or vice versa with Transpose Table Dimensions
If you need to restructure an entire table rather than simply switch rows and columns, use the Transpose Table Dimensions feature in Kutools for Excel. It can convert a cross table into a list table or convert a list table into a cross table.
After installing Kutools for Excel, follow these steps:
- Select the table you want to restructure.
- Click Kutools > Range > Transpose Table Dimensions.
- In the dialog box, select the required Transpose type, confirm the table range, and choose where to place the new table.
- Click OK to create the restructured table.
Frequently Asked Questions
What is the difference between Paste Transpose and Transform Range?
Paste Transpose switches the rows and columns of the entire copied range. Transform Range offers additional options, such as converting a single column into multiple rows and controlling how many items appear in each record.
What is the difference between Transform Range and Transpose Table Dimensions?
Transform Range reorganizes data from a single row or column. Transpose Table Dimensions restructures complete tables by converting between cross-table and list-table layouts.
Do these methods move the original data?
No. They create converted data in a new location and leave the original range unchanged. Delete the source data manually if you no longer need it.
Will the converted data update when the original data changes?
No. These methods produce static results that are not linked to the source range. Run the conversion again if the source data changes.
Why does Paste Transpose overlap the source range?
The output range may overlap the copied range if the destination cell is too close to the source. Select a blank area with enough space for the transposed result.
Best Office Productivity Tools
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...
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!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in