🔄 The Orientation Flipper

Goal: Rotate data from rows to columns.
TRANSPOSE swaps the X and Y coordinates. A 3x1 Vertical list becomes a 1x3 Horizontal row.

Input Array
⤵
Result Array
Ready...

💻 Formula Structure

=TRANSPOSE(array)
  • 1. Array: The range of cells to flip (e.g., A1:A5).
  • Result: A dynamic spill range with swapped dimensions.
-- Flip the array
=TRANSPOSE( A1:A3 )
New Dimensions:
-

⚠️ Common Pitfalls

🚫 Value Only
TRANSPOSE creates a copy of the values. It does not link formatting (colors, bold text) from the original cells.
💡 Paste Special
If you want to transpose data statically (without a formula) and keep formatting, use Copy > Paste Special > Transpose instead.