title: Big query - Concatenate strings horizontally
body: <p>I have a data with a column for the first name and a column for the last name.
  I try to combine the them into one column via code:</p>
  
  <pre><code>SELECT GROUP_CONCAT_UNQUOTED(full_name,' ') 
  from (Select first_name as check from [DATA]), 
       (select last_name  as check from [DATA])
  </code></pre>
  
  <p>But it returns a one row string with</p>
  
  <blockquote>
    <p>Anna Alex Emma Sean .... Miller Smith White ...</p>
  </blockquote>
  
  <p>but what I wanted was actually a column like</p>
  
  <pre><code>Anna Miller
  Alex Smith
  Emma White
  ...
  </code></pre>
  
  <p>Can you please tell me what I should do differently?
  Thanks!</p>