Using Excel built-in function "TRANSPOSE", a column result array can be transformed to one row.
Example:
The function EWMAi 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(4:
13)
becomes
=TRANSPOSE(EWMA(4:
13))
Now, select the range of cells in one row, hit F2 to enter editing mode, and hit CTRL+ALT+ENTER.
0 Comments