Formulas and Functions

Related Topics
For related functions and additional information, see:
“COLUMNS” on page 211
“Listing of Reference Functions” on page 206
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
TRANSPOSE
The transpose function returns a vertical range of cells as a horizontal range of cells,
or vice versa.
TRANSPOSE(range-array)
 range-array: The collection containing the values to be transposed. range-array is a
collection containing any type of value.
Usage Notes
TRANSPOSE returns an array containing the transposed values. This array will Â
contain a number of rows equal to the number of columns in the original range and
a number of columns equal to the number of rows in the original range. The values
in this array can be determined (“read”) using the INDEX function.
Examples
Given the following table:
row/column A B C D E
1 5 15 10 9 7
2 11 96 29 11 23
3 37 56 23 1 12
222 Chapter 9 Reference Functions