Placing an Array in One Row

Answer:

Using Excel built-in function "TRANSPOSE," you can transform a column result array into 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.