title: Import multiple ranges to a single sheet
body: <p>I have two different sheets, with two of the same ranges (age). I want to combine these two separate ranges into one on a different sheet. Current formula / function I am using:</p>
  
  <pre><code>={(importrange("https...", "Sheet1!A2:A100"));(importrange(""https...", "Sheet2!A2:A100"))}"))
  </code></pre>
  
  <p>What am I doing wrong?</p>
  
  <p>I was able to bring in one range at a time with this formula / function: </p>
  
  <pre><code>=IMPORTRANGE("https...", "Sheet1!A2:A100")
  =IMPORTRANGE("https...", "Sheet2!A2:A100")
  </code></pre>
  
  <p>but I need them to be in one column together (the order does not matter, I just need the values to be pulled across). </p>