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

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.

Comments

Please sign in to leave a comment.

Was this article helpful?
0 out of 0 found this helpful