title: How do I pull out multiple values in one column to create new rows with those values instead (repeating all other information from original row)?
body: <p>I have an Excel spreadsheet with 12+ columns and 200+ rows.  In one of the columns (ColB), there are multiple values associated with a single row.  I would like to convert such records to multiple rows with single value in Column B.  In other words, I'd like to convert this:</p>
  
  <hr>
  
  <p>[ColA]    [ColB]    [ColC]</p>
  
  <p>[blue]  [1, 4, 7] [open]<BR>
  [red]    [2, 3]     [closed]<br>
  [green]  [5]   [open]<br></p>
  
  <hr>
  
  <p>to this:</p>
  
  <hr>
  
  <p>[ColA]    [ColB]    [ColC]</p>
  
  <p>[blue]  [1] [open]<BR>
  [blue]  [4] [open]<BR>
  [blue]  [7] [open]<BR>
  [red]    [2]     [closed]<br>
  [red]    [3]     [closed]<br>
  [green]  [5]   [open]<br></p>
  
  <hr>
  
  <p>Any suggestions?   Thanks!</p>