title: Splitting a string column in BigQuery
body: <p>Let's say I have a table in BigQuery containing 2 columns. The first column represents a name, and the second is a delimited list of values, of arbitrary length. Example:</p>
  
  <pre><code>Name | Scores
  -----+-------
  Bob  |10;20;20
  Sue  |14;12;19;90
  Joe  |30;15
  </code></pre>
  
  <p>I want to transform into columns where the first is the name, and the second is a single score value, like so:</p>
  
  <pre><code>Name,Score
  Bob,10
  Bob,20
  Bob,20
  Sue,14
  Sue,12
  Sue,19
  Sue,90
  Joe,30
  Joe,15
  </code></pre>
  
  <p>Can this be done in BigQuery alone?</p>