[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
TRANSPOSE ( array )
Description: Creates a new array that is the transpose of an existing array, by copying the first row of the existing array to the first column of the new array, the second row of the existing array as the second column of the new array, and so on. The formula containing the call to TRANSPOSE shall be an array formula in a range that has the same number of rows and columns, respectively, as array has columns and rows.
Arguments:
|
Name |
Type |
Description |
|
array |
array, reference |
The set of values to be transposed. |
Return Type and Value: array – The new array.
[Example:
TRANSPOSE({10,20,30}) results in the array {10;20;30}
end example]