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 for:
2019 2016 365 2013 2010 2007
Ultimate Suite
Learn more
Transpose Range is part of Ultimate Suite for Microsoft Excel that solves 300+ Excel daily tasks
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-day money-back guarantee
Secure payment
guarantee
Life-time license,
no additional fees ever
Volume discounts: the more you buy, the less you pay
1 license for 2 or 5 PCs
or 1 server
Free life-time support
Learn more
  • This tool is part of Ultimate Suite
  • 60+ professional tools. No garbage.
Buy now
  • Buy as part of Ultimate Suite
  • 60+ professional tools. No garbage.

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

 

Excel

  • Excel 2019
  • Excel 2016
  • Excel 2013
  • Excel 2010
  • Excel 2007
  • 32-bit and 64-bit
  • Desktop Excel included in Office 365
  • Desktop Excel included in Office 365 ProPlus

Windows

  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7
  • 32-bit and 64-bit
Buy now
  • Buy as part of Ultimate Suite
  • 60+ professional tools. No garbage.

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