using A1 notation in array

Question

Hey,&nbsp;I am trying to achieve something that would seem reasonably simple but just doesn't work.&nbsp;I have 2 ranges e.g. A1:A3 and C6:C8 and I want to use these in an array.&nbsp;So when I use ={A1:A3,C6:C8} i except to see an output of:&lt;content of cell A1&gt;&lt;content of cell C6&gt;&lt;content of cell A2&gt;&lt;content of cell C7&gt;&lt;content of cell A3&gt;&lt;content of cell C8&gt;&nbsp;what i see instead is the incredible helpful error message of "the formula in this cell contains an error"&nbsp;I tried both both the column and row seperator ( , ; ) but both lead to the same error message.&nbsp;Any&nbsp;

sergeibaklan · Accepted Answer

jjbbss&nbsp;
{} is for array constants, not formulae. Use =HSTACK(&nbsp;A1:A3, C6:C8 )

<content of cell A1>	<content of cell C6>
<content of cell A2>	<content of cell C7>
<content of cell A3>	<content of cell C8>

Forum Discussion

using A1 notation in array

1 Reply