How do I transpose data in Excel?

Copy the range, use Paste Special, and choose Transpose. For dynamic results, use the TRANSPOSE function.

Is Paste Special Transpose dynamic?

No. Paste Special creates a static copy. Use the TRANSPOSE function for dynamic results.

What should I practice after reading this tutorial?

Rebuild the main example on a copy of your file, then change one argument at a time to see how the result changes. That builds muscle memory faster than rereading the steps.

Which Excel version do I need for the formulas in this article?

Most steps work in Excel 2016 and later. If the article mentions FILTER, UNIQUE, or XLOOKUP, you need Microsoft 365 or Excel 2021 — check the linked function pages for compatibility.

Tutorials - 2026-05-12

Transpose Data in Excel

Learn how to transpose data in Excel using Paste Special, the TRANSPOSE function, dynamic arrays, and Power Query for repeatable workflows.

What Transpose Means

Transposing data switches rows to columns or columns to rows. It is useful when data is structured in the wrong orientation for formulas, charts, or reports.

Transpose with Paste Special

Copy the range, choose a destination cell, then use: Paste Special -> Transpose This creates a static transposed copy.

Use the TRANSPOSE Function

\\\ =TRANSPOSE(A1:D5) \\\ In Microsoft 365, the result spills dynamically into multiple cells.

When to Use Power Query

Use Power Query when the transpose step must be repeated for new imported data. It is better for repeatable cleanup workflows.

Related Guides

TRANSPOSE function Excel Power Query Introduction Excel Text to Columns Excel Charts Guide

Apply this tutorial in your workbook

Copy one example from this article into a blank sheet. Change the sample ranges to match your column letters. Press F2 and Enter after edits so Excel recalculates. Compare your result to the expected output in the article. Related hubs: Excel functions directory · Formula guides · Function comparisons \nETL: Power Query intro · Remove duplicates

Frequently asked questions

How do I transpose data in Excel? Copy the range, use Paste Special, and choose Transpose. For dynamic results, use the TRANSPOSE function.
Is Paste Special Transpose dynamic? No. Paste Special creates a static copy. Use the TRANSPOSE function for dynamic results.
What should I practice after reading this tutorial? Rebuild the main example on a copy of your file, then change one argument at a time to see how the result changes. That builds muscle memory faster than rereading the steps.
Which Excel version do I need for the formulas in this article? Most steps work in Excel 2016 and later. If the article mentions FILTER, UNIQUE, or XLOOKUP, you need Microsoft 365 or Excel 2021 — check the linked function pages for compatibility.