Description Places a copy of the contents of a range into a new range in which the original rows are now columns and the original columns are now rows.
Note This is an array function. For information, see Array Functions.
Syntax TRANSPOSE ( range )
| Argument | Description |
|---|---|
| range | A range reference or the name of a named range reference. |
Results range Before entering this function, select a results range with the same number of rows as the argument range has columns and the same number of columns as the argument range has rows. If you select too few cells, some cells will be truncated. If you select too many cells, the extra cells will contain the #N/A error.
Example The following example uses this worksheet.
TRANSPOSE(A1:B5) returns the following results range:
See Also SIGN
