Row to column
| A | B | C | |
|---|---|---|---|
| 1 | Mon | Tue | Wed |
Formula: A3: =TRANSPOSE(A1:C1)
Result: Spills down: Mon, Tue, Wed
The three entries of the row spill down in a column starting at A3.
Google Sheets function
TRANSPOSE in Google Sheets
TRANSPOSE spills its result in Google Sheets without ARRAYFORMULA, swapping rows and columns of a range.
Syntax (same in Google Sheets)
TRANSPOSE(array)The result is live: change the source and the transposed block follows.
For a fuller explanation of the arguments and common errors, see the TRANSPOSE Excel guide.
Worked examples in Google Sheets
Dot product of a column and a row
| A | B | C | D | |
|---|---|---|---|---|
| 1 | x | y | z | |
| 2 | 2 | 1 | 2 | 3 |
| 3 | 3 | |||
| 4 | 4 |
Formula: F2: =SUMPRODUCT(A2:A4,TRANSPOSE(B2:D2))
Result: 20
The row 1, 2, 3 is turned into a column and multiplied element by element with 2, 3, 4.
One element of a flipped block
| A | B | |
|---|---|---|
| 1 | a | b |
| 2 | c | d |
| 3 | e | f |
Formula: D1: =INDEX(TRANSPOSE(A1:B3),2,3)
Result: f
The 3-row block becomes 2 rows by 3 columns, and row 2, column 3 is the original B3.
Try it
A tiny spreadsheet with example data. Edit the formula or any number and see the result.
Formula in F2: =TRANSPOSE(A1:B3)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | ID | Item | Price | Stock | Result | |||
| 2 | 101 | Pen | 2.5 | 120 | ID | 101 | 102 | |
| 3 | 102 | Notebook | 4 | 80 | Item | Pen | Notebook | |
| 4 | 103 | Lamp | 25 | 15 | ||||
| 5 | 104 | Mug | 7.5 | 40 | ||||
| 6 | 105 | Backpack | 39 | 12 |
Result in F2: ID
Frequently asked questions
- Is TRANSPOSE better than Paste special, Transposed in Google Sheets?
- It depends. The formula stays linked to the source and updates; Paste special, Transposed makes a one-off copy that you can edit.
Google Sheets is used here only as a descriptive product name. FormulaCamp is not affiliated with Google.