title: Pulling Multiple Columns from Different Sheets into Single Column
body: <p>I have 50 sheets representing 50 states in a single Spreadsheet, and of those states, I'm trying to consolidate from an input column (Col4 on all sheets, Column 'City' formatted like this: 'Austin, TX') into a single index column to pull from to build a City-plotted map. (I'm using Marker Maps in Google Sheets for this). </p>
  
  <p>However, I keep running into errors trying to accomplish this task.</p>
  
  <p>I've used <code>=QUERY()</code> to pull in 2 sheets (2 sheets to make it easy).</p>
  
  <pre><code>=QUERY({AL!D2:D10; AK!D2:D10},"SELECT * WHERE Col4 &gt; 0")
  </code></pre>
  
  <p>However, I get a </p>
  
  <blockquote>
    <p>'Query Completed with an empty output' Error.</p>
  </blockquote>
  
  <pre><code>=QUERY({AL!D2:D10; AK!D2:D10},"SELECT *")
  </code></pre>
  
  <p>Works, but I'm only getting the AL city results pulled in, 'Auburn, AL' but no 'Anchorage, AK'.</p>
  
  <p>I've tried varying Select statements to see if it would work, but I cannot get more than a single sheet's Column pulled in.</p>
  
  <p>If anyone has any better suggestions on how to do this, or have an idea why I'm receiving errors or doing it wrong, please assist.</p>