Array formula: how to join 2 ranges together to form one array?

[Rich_84]

Hi,

I'm familiar with array formulas such as:

{=A1:A3}

But is there a way to join two ranges togther e.g. a formula to join the
ranges A1:A3 and B1:B3 into a single 6*1 sized array? I was thinging along
the lines of:

{=A1:A3,B1:B3}

But it doesn't seem to be what I'm looking for.

Thanks,

Richard

 

[Domenic]

Can you explain what it is you're trying to do once you have your array?

 

[Dave Peterson]

Check your other post.

Hi,

I'm familiar with array formulas such as:

{=A1:A3}

But is there a way to join two ranges togther e.g. a formula to join the
ranges A1:A3 and B1:B3 into a single 6*1 sized array? I was thinging along
the lines of:

{=A1:A3,B1:B3}

But it doesn't seem to be what I'm looking for.

Thanks,

Richard