How do I convert rows to columns in Excel (transpose)?

Transposing flips a table 90° — rows become columns and vice versa.

Method 1 — Paste Special

1. Select and copy the data (Ctrl+C)
2. Click where you want to paste
3. Right-click → Paste Special
4. Check Transpose
5. Click OK

The data pastes rotated. This is a copy — no link to the original.

Method 2 — TRANSPOSE Function

For a dynamic link (changes in the source reflect automatically):

1. Select the target area (e.g., 5 columns × 3 rows if the source is 3×5)
2. Enter the formula: =TRANSPOSE(A1:E3)
3. Press Ctrl+Shift+Enter (for older Excel versions)

In Excel 365/2021, just press Enter — the formula spills automatically.

Tip

Before transposing large tables, make sure you have enough room in the target area.