Syntax or pattern
Switch rows into columns or columns into rows.
=TRANSPOSE(array_or_range)5 practical examples
Apply TRANSPOSE to a whole column
Fill calculated results automatically as new rows are added.
=ARRAYFORMULA(IF(A2:A="",,B2:B*C2:C))Adjust the ranges, criteria and sheet names to match your workbook.
Return active rows
Create a live view of active records.
=FILTER(A2:E, D2:D="Active")Adjust the ranges, criteria and sheet names to match your workbook.
Sort a report table
Sort rows by the fifth column in descending order.
=SORT(A2:E, 5, FALSE)Adjust the ranges, criteria and sheet names to match your workbook.
List unique categories
Return a clean list of distinct categories.
=UNIQUE(B2:B)Adjust the ranges, criteria and sheet names to match your workbook.
Generate row numbers
Create automatic numbering for non-empty records.
=SEQUENCE(COUNTA(A2:A))Adjust the ranges, criteria and sheet names to match your workbook.
Common mistakes to avoid
- Putting manual values inside a spill output range.
- Using full-column ranges on very heavy sheets without need.
- Forgetting that one formula can fill many rows.
FAQ
What is this Google Sheets page for?
This page gives copy-ready examples for transpose examples so you can understand the pattern and adapt it to real spreadsheet work.
Can I copy these formulas directly?
Yes. Use the copy buttons, then adjust sheet names, ranges, criteria and column references for your own file.
Why does my formula return an error?
The most common causes are mismatched ranges, missing quotes around text criteria, blank source data, or references that do not match your sheet layout.