Formula guide · Excel and Google Sheets · Updated May 13, 2026
Transpose Rows and Columns
Flip rows into columns or columns into rows with the TRANSPOSE formula.
Quick Answer
Use TRANSPOSE to dynamically flip a vertical range into a horizontal range or the reverse.
Copyable Formula
=TRANSPOSE(A2:A10)Syntax
=TRANSPOSE(range)Excel and Google Sheets
Worked Example
| A | Output |
|---|---|
| Jan | Jan, Feb, Mar across columns |
| Feb | |
| Mar |
Result: Returns the vertical list across a row.
Steps
- Select the source range.
- Wrap it in TRANSPOSE.
- Place the formula where there is enough spill space.
- Use paste special transpose only when you need a static copy.
Common Mistakes
- Blocking the spill range.
- Using paste transpose when the output should update dynamically.
- Transposing a range with merged cells.
Excel vs Google Sheets Notes
The core idea works in both Excel and Google Sheets, but separators, function availability, and array behavior can vary by account, locale, and version.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.