title: Combining multiple spreadsheets in one using IMPORTRANGE
body: <p>I would like to aggregate the data of multiple spreadsheets into one spreadsheet.</p>
  
  <ul>
  <li>Spreadsheet 1 has a Row of Strings A2:A500</li>
  <li>Spreadsheet 2 has a Row of Strings A2:A500</li>
  <li>Spreadsheet 3 is supposed to have a Row of both (Spreadsheet1!A2:A500 AND Spreadsheet2!A2:A500). </li>
  </ul>
  
  <p>Duplicates shall not be handled differently. I would like them to appear as often as they appear in the different sheets.</p>
  
  <p>Is it possible to do this without writing a script or using jQuery, e.g. by using IMPORTRANGE?</p>
  
  <p><strong>What does not work:</strong> I have tried using IMPORTRANGE as follows: </p>
  
  <pre><code>ARRAY{IMPORTRANGE("key-of-spreadsheet1","list!A2:A500"), IMPORTRANGE("key-of-spreadsheet2", "list!A2:A500")}
  </code></pre>
  
  <p>This causes an error.</p>