Transpose data in Excel

Convert rows to columns and vice versa

Switch rows and columns in Excel 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.

Learn more
This tool is part of
Ultimate Suite
Transpose range for Excel 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 30-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 computers
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

About Transpose Range

Supported versions

 

Excel

  • 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
  • Windows Vista
  • Windows XP
  • 32-bit and 64-bit
Free download
14-day trial version
  • Included in Ultimate Suite for Excel
  • 14-day fully-functional version

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.
Excel add-ins and Outlook tools - Ablebits.com