Array Functions
Advanced
TRANSPOSE Function
Convert rows to columns or columns to rows.
Task:
Transpose the data from rows to columns using the TRANSPOSE function.
Learning Objectives:
- Learn TRANSPOSE function
- Understand array manipulation
- Practice data restructuring
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Data 1 | Data 2 | Data 3 | Data 4 | Data 5 |
| 2 | 1 | 2 | 3 | 4 | 5 |
| 3 | Transposed Data | ||||
| 4 | |||||
| 5 | |||||
| 6 | |||||
| 7 |
What this exercise teaches (contains the answer)
TRANSPOSE converts a vertical range to horizontal or vice versa, useful for rotating data layouts.