title: Combine two data ranges into one range (Google Drive Excel)
body: <p>Hi there I am looking to combine two data ranges/arrays into one in order to feed them into excel <code>FREQUENCY</code> function.</p>
  
  <p>Example:
  First data range - <code>B5:F50</code>
  Second data range - <code>J5:N50</code>
  Bins data range - <code>I5:I16</code>
  Function definition - <code>FREQUENCY(data_array; bins_array)</code></p>
  
  <p>Basically I am lazy and I don't want to reshuffle my excel script to spit out both datasets side by side so that I can reference them using something like <code>B5:K50</code> range. Is there any way I can combine both datasets into <code>data_array</code> using some kind of formula? Maybe to end up with something along the line of <code>=FREQUENCY((B5:F50,J5:N50); I5:I16)</code> ?</p>
  
  <p>BTW: Either of</p>
  
  <pre><code>=FREQUENCY(B5:F50; I5:I16)
  =FREQUENCY(J5:N50; I5:I16)
  </code></pre>
  
  <p>work just file on their own for me.</p>
  
  <p><strong>Update</strong></p>
  
  <p><a href="https://support.google.com/docs/answer/3094286" rel="nofollow noreferrer">Actual formula definition <code>FREQUENCY(data, classes)</code></a></p>
  
  <p><strong>2013 MS Excel (unrelated)</strong></p>
  
  <p><img src="https://i.stack.imgur.com/LP4sx.png" alt="enter image description here"></p>