If your Excel data runs across columns and you need it to run down rows, the simplest tool is Transpose. You can transpose a one-time copy with Paste Special or use the TRANSPOSE function when the new layout should remain linked to the source.
Turn columns into rows with Paste Special
- Select the cells you want to rotate.
- Press Ctrl + C to copy them.
- Select the upper-left cell where the rotated data should begin.
- Open the Paste menu and choose Transpose, or use Paste Special > Transpose.
Excel switches rows to columns and columns to rows in the pasted copy. Make sure the destination area has enough empty cells so the result does not overwrite other data.
Use TRANSPOSE for a linked result
If the destination should update when the source changes, use a formula such as =TRANSPOSE(A1:D5). In current Microsoft 365 versions of Excel, enter the formula in the upper-left destination cell and the result spills into the required range automatically.
Older versions of Excel may require TRANSPOSE to be entered as an array formula across a preselected destination range. That difference is important when following instructions written for another Excel version.
Paste Special versus TRANSPOSE
Paste Special creates a new copy. Editing the original cells afterward does not update the transposed copy. The TRANSPOSE function creates a formula-based result that remains connected to its source.
Choose Paste Special when you want to rearrange data permanently. Choose the function when the source remains the authoritative data set.
What happens to formulas and formatting?
Paste behavior can vary depending on the paste option you choose, and relative formula references may adjust when copied. Check formulas after transposing a calculation-heavy range. A TRANSPOSE formula returns values through the formula result rather than recreating the source cells as independently editable copies.
If “pivot” means summarizing data
Transposing is different from creating a PivotTable. A PivotTable groups and summarizes records—for example, sales by region and month. Transpose simply rotates an existing rectangular range. If your goal is aggregation rather than orientation, use Insert > PivotTable instead.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.