title: Google Sheets QUERY with WHERE on multiple columns
body: <p>I'm building a Google Sheet table and I am stuck on a specific query I want to make</p>
  <p><a href="https://i.stack.imgur.com/I7RZp.png" rel="nofollow noreferrer">Source Table pic here</a></p>
  <p>I need to sort my Names by &quot;Type&quot; and by &quot;ValueType&quot;.
  I managed to sort them by &quot;Type&quot; with ease, but i'm stuck on the sort by &quot;ValueType&quot; part, because they are in columns, not lines and I can't manage to find a way to sort them by columns</p>
  <p>My Query looks like this right now</p>
  <blockquote>
  <p>=QUERY(A1:G8; &quot;SELECT * WHERE A='Type1'; 1)</p>
  </blockquote>
  <p>I want it to look something like this :</p>
  <blockquote>
  <p>=QUERY(A1:G8; &quot;SELECT * WHERE A='Type1' AND C1:G1='ValueType 1'&quot;; 1)</p>
  </blockquote>
  <p>Is it possible to do something like this, and if so, can you please tell me what is the syntax?</p>
  <p>Thanks in advance.</p>