Placing an Array in One Row


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.


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.




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


Please sign in to leave a comment.

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