title: Joining ( {} ) 2 separately working queries gives a value error
body: <p>I've got this query </p>
  
  <pre><code>=query(importrange("link";"Sales!A2:F");"Select Col1,Col3,Col4,Col5,Col6  where Col2='Manager'")
  </code></pre>
  
  <p>That gets the data in this format</p>
  
  <p>Date | Name | Sum | DOP | Comment</p>
  
  <p>And I've got this formula </p>
  
  <pre><code>=query(importrange("link";"Sales!A2:F");"Select Sum(Col4) where Col2='Manager' label Sum(Col4) ''")
  </code></pre>
  
  <p>That gives me the total of column "Sum"</p>
  
  <p>They work fine separetly,but when I join them together with {} , like so:</p>
  
  <pre><code>={query(importrange("link";"Sales!A2:F");"Select Col1,Col3,Col4,Col5,Col6  where Col2='Manager'");query(importrange("link";"Sales!A2:F");"Select Sum(Col4) where Col2='Manager' label Sum(Col4) ''")}
  </code></pre>
  
  <p>I get a</p>
  
  <pre><code>In ARRAY_LITERAL, an Array Literal was missing values for one or more rows
  </code></pre>
  
  <p>The intended behavior is that the joined formula will output the table of data, and underneath the total of sum.</p>
  
  <p>Reason for the formula, eventually there will be 12 of those that will additionally sort the source data by month and get the "Table/Total" of each month.</p>
  
  <p>Maybe "query" is not the best way to do it, if so then I will be thrilled to learn a more efficient way!</p>
  
  <p>Please keep in mind that in your region, the ";" inside formulas might need to be replaced with "," </p>