Quote Originally Posted by Rick Rothstein View Post
Can you provide us with some more details please. What kind of arrays are you talking about...
Hi, I have another interesting example.

I have two or more columns that I would like to combine to matrix. I have tried solutions like =(c_1:c_2) and =CHOOSE({1;2};TRANSPOSE(c_1;TRANSPOSE(c_2)), but they work only for ordinary cell values or easy formulas like =ROW(2:5)-ROW(1:4) (that creates ones).
My columns are complicated formulas like

=IFERROR(INDEX(ROW(3:10)-ROW(3:10); ROWS(C$1:$C3)); IFERROR(INDEX(ROW(4:5)-ROW(3:4); ROWS(C$1:$C3)-ROWS(ROW(3:10)-ROW(3:10))); "")).

This is a complicated formula for a single cell.
How could I combine two such columns into matrix?
I would be the happiest if Excel would come out with some simple formula like JOIN.

Thank you
Marko