|
TRANSPOSE |
  
|
|
TRANSPOSE |
|
This function returns a vertical range of cells as a horizontal range or a horizontal range of cells as a vertical range.
Syntax
TRANSPOSE(array)
Arguments
The array argument is a range of cells or an array that you want to switch.
Remarks
This function uses the first row of the array as the first column of the new array and so on.
Use the INDEX function to get individual elements from the returned array.
Data Types
Accepts an array. Returns an array.
Examples
TRANSPOSE(A2:A5)
See Also