Transpose data in Excel

Convert rows to columns and vice versa

Switch rows and columns in Excel 2019, 2016 - 2007 with the Transpose Range add-in. Transpose data and paste values only, or values and formulas, or create links to the source data. Place the transposed table in the current workbook or a new one.

Free download Ultimate Suite for:
2019 2016 365 2013 2010
Transpose range for Excel 2019, 2016 - 2007

With Transpose Range you will

  • Paste your data the way you need it Transpose data in Excel and choose to preserve formulas, paste values only, or create links to the source data.
  • Choose a place for the result Switch columns and rows and get your table in the same file or in a new one.

How to convert row to column in Excel and vice versa

  
Choose a paste option and a place for the result, click on Transpose
Choose a paste option and a place for the result, click on Transpose
The transposed table is inserted into the new worksheet
The transposed table is inserted into the new worksheet
Choose a paste option and a place for the result, click on Transpose
The transposed table is inserted into the new worksheet

License benefits

Our customers get

Unconditional 60-days money-back guarantee
Life-time license, no additional
fees ever
Free life-time support
Secure payment guarantee
Volume discounts: the more you buy, the less you pay

These companies choose Ablebits products

Frequently asked questions

What is Transpose Range and what do I need it for?

The Excel Transpose Range tool converts columns to rows. It rotates your table, so you don't have to waste your time on copying and pasting.

How to change row to column in Excel?

Select any cell in your table and start the Transpose Range add-in, that will automatically select the entire table. Choose how you'd like to paste the data: insert cells with formatting, paste only values, or create references to the source data. Select, where to save the result: to a new sheet or workbook. Click Transpose button.

Find a more detailed description here.

In my new table I need to preserve the links to the source data, is it possible?

Yes, just tick off the corresponding option and create a new table with all links preserved.

There are formulas in my original table and I need to save them while converting, will Transpose Range help?

Sure, you can change rows to columns without loosing your formulas. Just tick off Paste all option.

Where will I find my new table?

There are two opportunities to place your new table: to the new sheet in the current workbook or to the new workbook.

Supported versions

Microsoft Excel

  • Excel included in ​Microsoft 365 (formerly Office 365)
  • Excel 2019
  • Excel 2016
  • Excel 2013
  • Excel 2010
  • 32-bit and 64-bit
  • Note! Office Insider is not supported

Windows

  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7
  • 32-bit and 64-bit
  • Note! Windows insider is not supported
  • Note! Surface Pro X and Windows X are not supported

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.

Your message was successfully sent.

Thank you for contacting us!
We will get back to you shortly.

You will receive a delivery confirmation for your message within a few minutes. If you don't get it, please re-send your message and make sure you entered a valid e-mail address.

Close