title: How to autofill NULL values when using SPLIT formula in SQL?
body: <p>So I'm trying to figure out how I would go about using the <code>SPLIT</code> function in Big Query SQL while filling in the <code>NULL</code> values that associate with when using the <code>SPLIT</code> function. For this example I have two columns in my table currently and looks like this:</p>
  
  <pre><code>    Name             |           Price
   Jake                |       19.99,20.00,21.00
   Jane                |       15.00,13.99,14.00
   Joe                 |       17.99,12.00,15.00,17.99
   John                |       18.00,10.00
  </code></pre>
  
  <p>The output I'm getting currently when I do, <code>SPLIT(Price, ',') AS Price_Split</code> is the following:</p>
  
  <pre><code>    Name             |           Price
   Jake                |       19.99
                       |       20.00
                       |       21.00
   Jane                |       15.00
                       |       13.99
                       |       14.00
   Joe                 |       17.99
                       |       12.00
                       |       15.00
                       |       17.99
   John                |       18.00
                       |       10.00
  </code></pre>
  
  <p>What I'm trying to make my end result look like is:</p>
  
  <pre><code>    Name             |           Price
   Jake                |       19.99
   Jake                |       20.00
   Jake                |       21.00
   Jane                |       15.00
   Jane                |       13.99
   Jane                |       14.00
   Joe                 |       17.99
   Joe                 |       12.00
   Joe                 |       15.00
   Joe                 |       17.99
   John                |       18.00
   John                |       10.00
  </code></pre>
  
  <p>How would I go about auto filling in the Names that correspond correctly? Or should I go about this a different way/different formula? Any help with this would be much appreciated!!</p>