Guide Excel

How to Transpose Rows and Columns in Excel

Transposing data allows you to quickly switch the orientation of your table without retyping information. This guide covers both the static Paste Special method and the dynamic formula approach.

Le faire avec l'IA

Étape par étape

1
Select and Copy Data
Highlight the range of cells you want to transpose and press Ctrl + C to copy them.
2
Open Paste Special
Right-click the destination cell where you want the data to start, then select 'Paste Special'.
3
Apply Transpose
In the Paste Special dialog box, check the 'Transpose' box and click OK.

=TRANSPOSE(array)

Astuces

Use the TRANSPOSE function if you want the output to update automatically when the original data changes.

FAQ

What is the difference between Paste Special and the TRANSPOSE function?

Paste Special creates a static copy, while the TRANSPOSE function creates a dynamic link that updates if the source data changes.