title: Is there a way to concatenate two arrays in Excel without VBA?
body: <p>I am trying to create a formula that returns the concatenation of two arrays of different lengths. I need this concatenation for part of another formula and I would like to avoid "helper" rows, if possible.</p>
  
  <p>See below for example data.</p>
  
  <p><a href="https://i.stack.imgur.com/zKg5x.png" rel="noreferrer"><img src="https://i.stack.imgur.com/zKg5x.png" alt="enter image description here"></a></p>
  
  <p>The goal is to have the output be <code>{10;11;12;13;20;21;22}</code>. Of course, this can easily be hardcoded into the formula but these values are dynamic so that is not an option.</p>
  
  <p>I tried the following:</p>
  
  <pre><code>{A1:A4;B1:B3}
  </code></pre>
  
  <p>but this is apparently not valid Excel syntax.</p>
  
  <p>Is there a solution?</p>