title: How to use CONCAT in QUERY?
body: <p>I have a table:</p>
  
  <pre><code> A     |   B      |     C
  BEN    |  MOSKOW  |    YES
  ANTON  |  IRKUTSK |     NO
  VIKTOR |  PARIS   |    YES
  BEN    |  PARIS   |    YES
  ANTON  |  TORONTO |     NO
  DON    | TORONTO  |    YES
  ANNA   | IRKUTSK  |    YES
  BEN    |  MOSKOW  |     NO
  </code></pre>
  
  <p>and tried a formula:</p>
  
  <pre><code>=UNIQUE(query(A:C; "Select A,B,C where A contains 'BEN' OR A contains 'ANTON' order by A"))
  </code></pre>
  
  <p>and an arrayformula:</p>
  
  <pre><code>=arrayformula(UNIQUE(query(A:C; "Select A,B,C where A contains 'BEN' OR A contains 'ANTON' order by A")))
  </code></pre>
  
  <p>but the results are in columns:</p>
  
  <pre><code>ANTON  |  IRKUTSK |     NO
  ANTON  |  TORONTO |     NO
  BEN    |  MOSKOW  |    YES
  BEN    |  PARIS   |    YES
  BEN    |  MOSKOW  |     NO
  </code></pre>
  
  <p>whereas I need results in only one cell per row, like so:</p>
  
  <pre><code>ANTON IRKUTSK NO
  ANTON TORONTO NO
  BEN MOSCOW YES
  BEN PARIS YES
  BEN MOSKOW NO
  </code></pre>