How can I place the returned array from Function XYZ in one row?

Using Excel built-in function "TRANSPOSE", a column result array can be transformed to one row.

Example:

The function EWMAⁱ returns an array of values ordered in one column. To re-order the column into a row, pass the EWMA function formula to TRANSPOSE.

=EWMA( $A$ 4: $A$ 13)

becomes

=TRANSPOSE(EWMA( $A$ 4: $A$ 13))

Now, select the range of cells in one row, hit F2 to enter editing mode, and hit CTRL+ALT+ENTER.

Have more questions? Submit a request

NumXL Support Desk