title: Split comma separated entries to new rows
body: <p>I currently have this data in a sheet</p>
  
  <pre><code>Col A   Col B
  1       angry birds, gaming
  2       nirvana,rock,band
  </code></pre>
  
  <p>What I want to do is split the comma separated entries in the second column and insert in new rows like below:</p>
  
  <pre><code>Col A   Col B
  1   angry birds
  1   gaming
  2   nirvana
  2   rock
  2   band
  </code></pre>
  
  <p>I am sure this can be done with VBA but couldn't figure it out myself.</p>