title: Big Query - Transpose arrays into colums
body: <p>We have a table in Big Query like below.</p>
  <p>Input table:</p>
  <pre><code> Name | Interests
   -----+----------
   Bob  | [&quot;a&quot;]
   Sue  | [&quot;a&quot;,&quot;b&quot;]
   Joe  | [&quot;b&quot;,&quot;c&quot;]
  </code></pre>
  <p>We want to convert the above table to below format to make it BI/Visualisation friendly.</p>
  <p>Target/Required table:</p>
  <pre><code> +------------------+
   | Name | a | b | c |
   +------------------+
   | Bob  | 1 | 0 | 0 |
   | Sue  | 1 | 1 | 0 |
   | Joe  | 0 | 1 | 0 |
   +------------------+
  </code></pre>
  <p><strong>Note:</strong> The Interests column is an array datatype. Is this sort of transformation possible in Big Query? If yes, Any reference query?</p>
  <p>Thanks in advance!</p>