title: How to resolve an "ARRAY_LITERAL" error in Google Sheets
body: <p>Keep getting the &quot;In ARRAY_LITERAL, an Array Literal was missing values for one or more rows&quot; error for this query:</p>
  <pre><code>=query({'Silent Auction Items'!A2:B263;'Raffle Tickets'!A2:B74,'Winner''s Choice Raffle'!A2:B74;'Greeting Cards'!A2:B74;'Live Auction Items'!A2:B27;'Dessert Dash'!A2:B74;'Heads or Tails Raffle'!A2:B74;Ask!A2:B74;'Credit Card Fee Donation'!A2:B74;'Other Donation'!A2:B74},&quot;select * where Col1=133&quot;)
  </code></pre>
  <p>I tested this with each tab separately (e.g., <strong>{'Silent Auction Items'!A2:B263}</strong>) and it worked each time, returning the same number of columns if there was no purchase in a category (i.e., <strong>133, $0.00</strong>), so I'm not finding the problem yet.</p>
  <p>Each tab is for a different category of purchase bidders can make at an auction. Col1 in each tab is a BidderNumber field. So, in this example, I'm filtering for all the purchases made by Bidder 133.</p>
  <p>(Larger background: Trying to repurpose an MS Access database for Google Sheets, which is more familiar to our volunteers.)</p>