title: Trying to Combine 2 Google Sheets tabs into one
body: <p>I need to use the Query method for this as it needs to be updated automatically whenever new data appears on either sheets.</p>
  <p>Here is what I have so far, but it says: &quot;Query completed with an empty output&quot;</p>
  <pre><code>=query({IMPORTRANGE(&quot;GOOGLE_SHEET_URL&quot;, &quot;Bing!A2:J&quot;); IMPORTRANGE(&quot;GOOGLE_SHEET_URL&quot;, &quot;Google!A2:J&quot;)}, &quot;select * where Col1 &lt;&gt;''&quot;)
  </code></pre>