To switch rows and columns in Google Sheets, copy a range and use Paste special → Transposed, or use the TRANSPOSE function for a live link back to the source range. Finance teams often transpose when a monthly P&L is easier to chart one way and easier to review the other.

When transpose shows up in FP&A work

You might build a portrait table (accounts down, months across) for variance review, then transpose a subset for a landscape chart or slide. Paste special gives you a static snapshot. TRANSPOSE keeps the flipped view tied to the source cells. Neither replaces clean source data. For live actuals in Sheets, use LiveFlow FP&A.

How to interchange rows and columns with Paste special

1. Select the range you want to transpose.

2. Copy it: Ctrl + C (Windows) or ⌘ + C (Mac).

3. Click the cell where the transposed range should start.

4. Right-click → Paste special → Transposed.

Example: a portrait monthly revenue table for six months becomes a landscape layout with months as rows (or vice versa). Formatting and values both move with Paste special → Transposed.

Paste values only after a transpose

If you need values without formatting:

1. Transpose with Paste special first.

2. Copy the transposed range.

3. Paste elsewhere with Paste values only (or Paste as values).

Static vs live transpose

A Paste special transpose is not linked to the original range. Later edits in the source do not flow through. If you need a live flipped view, use `=TRANSPOSE(range)` instead so changes in the source update automatically.

TRANSPOSE function (optional live method)

In an empty area of the sheet, enter:

```

=TRANSPOSE(A1:G20)

```

Replace the range with your source. Leave enough empty rows and columns for the flipped shape, or Sheets will return a spill error.

How do you group and ungroup rows and columns in Google Sheets?

Grouping is separate from transpose. Use Data → Group (or the row/column context menu) when you want collapsible sections in a report outline, not a flipped layout.

Why finance teams use LiveFlow

Transposing fixes orientation. It does not fix stale books data. LiveFlow for Google Sheets keeps P&L, balance sheet, and budget vs actuals ranges updating from QuickBooks so the table you transpose is already current. If you are pasting entity exports just to reshape them, start with live imports instead.

CTA: Book a demo to connect QuickBooks to Google Sheets with LiveFlow FP&A.