title: SQL - Grouping creating new columns
body: <p>Good morning,</p>
  <p>I'm a bit stuck in this problem, I would like to know if it's possible to group by a column getting the rest of columns from this one in new dynamic columns.</p>
  <p>I'm going to try to explain the problem with an example:</p>
  <p>For example:</p>
  <pre><code>+-------+---------+-----+------+
  | Class |  Name   | Age | Size |
  +-------+---------+-----+------+
  | 1     | Pepe    | 10  | S    | 
  | 1     | Antonio | 12  | M    | 
  | 2     | Rosa    | 13  | M    | 
  | 2     | Antonio | 13  | S    | 
  | 2     | Amparo  | 12  | S    |
  | ...   | ...     | ... | ...  |
  | n     | n       | n   | n    | 
  +-------+---------+-----+------+
  </code></pre>
  <p>To get the result in this way:</p>
  <pre><code>+-------+--------+-------+--------+------------+-------+--------+--------+-------+--------+-----+--------+-------+--------+
  | Class | Name_1 | Age_1 | Size_1 |   Name_2   | Age_2 | Size_2 | Name_3 | Age_3 | Size_3 | ... | Name_n | Age_n | Size_n |
  +-------+--------+-------+--------+------------+-------+--------+--------+-------+--------+-----+--------+-------+--------+
  |     1 | Pepe   |    10 | S      | Antonio    | 12    | M      |        |       |        |     |        |       |        |
  |     2 | Rosa   |    13 | M      | Antonio    | 13    | S      | Amparo | 12    | S      |     |        |       |        |
  +-------+--------+-------+--------+------------+-------+--------+--------+-------+--------+-----+--------+-------+--------+ 
  </code></pre>
  <p>I was trying to solve it in BigQuery, using pivot but I didn't get the result I want it.</p>
  <p>Thank you in advance</p>