Formulas and Functions
Modifying this control will update this page automatically

TRANSPOSE

The TRANSPOSE function returns a vertical collection of cells as a horizontal array of cells, or vice versa.

TRANSPOSE(range-array)

range-array: The collection containing the values to be transposed. range-array can contain any value.

Notes

  • TRANSPOSE returns an array containing the transposed values. This array contains a number of rows equal to the number of columns in the original collection and a number of columns equal to the number of rows in the original collection.

Examples

Given the following table:

A

B

C

D

E

1

5

15

10

9

7

2

11

96

29

11

23

3

37

56

23

1

12

=TRANSPOSE(A1:E3) returns the table below.

1

2

3

1

5

11

37

2

15

96

56

3

10

29

23

4

9

11

1

5

7

23

12

See alsoINDEX
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.