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 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($ 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

0 Comments