How to transpose data in Excel

The Excel's Transpose Range tool flips rows and columns in your table. If you need to reshape your worksheet for further processing, use this add-in's functionality and get quick results. Follow the steps below to convert rows to columns or columns to rows in your Excel table.

How to transpose a range in Excel

Open the workbook with your data to transpose and click the Transpose icon in the Transform group on the Ablebits Tools tab in Excel:
Run Transpose.

You can see the Transpose Range pane with the following options:
Transpose Excel range.

  1. By default, the add-in highlights the whole range with data in your worksheet. You can select the needed range in your Excel worksheet or enter it manually in this field.
  2. To get the used range highlighted again, select a single cell in the table and click the Expand selection icon.
  3. You can also change the range by clicking the Select range icon and choosing it manually.
  4. Decide how you want to paste the results:
    • Paste all. If your original table contains formulas, they will be pasted together with their values.
    • Paste values only. Select this radio button if you don't want to transfer formulas into the resulting table.
    • Create links to source data. This will automatically update the results when the source data changes.
  5. Now you can pick the location for the resulting table:
    • Select the New worksheet radio button to get the table in the existing workbook.
    • Click New workbook to create another file.

Click the Transpose button to see the results.


Is there an easy way to transpose multiple rows of data into a single cell (as opposed to transposing into the same number of columns as rows)?


Hi Rob,
Thank you for your comment. If I have understood your task correctly, the Merge Cells tool should help you:

Please do not hesitate to contact us with any other questions.


Post a comment

Seen by everyone, do not publish license keys and sensitive personal info!

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at