title: How to Split a Cell Part of a Row and Keep the Rest of the Rows - Google Spreadsheets
body: <p>I am trying to do the following:  I have row 1.  I have values A1, B1, and C1.  A1 contains a few names separated by a comma.  I want to split A1 by these names while copying over the values from B1 and C1 into the split columns of A1.</p>
  
  <p>For example, I have this:</p>
  
  <pre><code>(A1              B1      C1)
  bob,sam,bill     99      10
  </code></pre>
  
  <p>I want to have this:</p>
  
  <pre><code>bob              99      10
  sam              99      10
  bill             99      10
  </code></pre>
  
  <p>I am also doing this on Google Sheets, I tried using combinations of Split, Join, and Transpose but can't seem to figure it out.  </p>
  
  <p>Any help would be appreciated, thanks.
  EDIT: any updates?
  EDIT: still trying to figure this out.</p>