Description
The Excel Transpose function 'transposes' an array of cells (ie. the function copies a horizontal range of cells into a vertical range and vice versa).
Array Formulas:
To input an array formula, you need to first highlight the range of cells for the function result. Type your function into the first cell of the range, and press CTRL-SHIFT-Enter.
Go to the Excel Array Formulas page for more details.
Go to the Excel Array Formulas page for more details.
The format of the function is :
TRANSPOSE( array )
Where the array argument is a range of Excel spreadsheet cells.
As the transpose function returns an array of values, it must be entered as an Array Formula.
No comments:
Post a Comment