title: Split comma separated entries to new rows while keeping row data
body: <p>I do not know vba at all so I was wondering if someone could help me out with a VBA code I'm trying to create.
  I have bunch of data that I have. I have data in columns A to W. </p>
  
  <p>I had one column that has multiple data separated out by commas like so:</p>
  
  <pre><code>Col V  |  Col W 
  ----   |  ----
  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 V|Col W
  ---- |----
  1    |angry birds
  1    |gaming
  2    |nirvana
  2    |rock
  2    |band
  </code></pre>
  
  <p>Basically, I want to replicate this </p>
  
  <p><a href="https://stackoverflow.com/questions/41003866/excel-macro-split-comma-separated-entries-to-new-rows">Excel macro -Split comma separated entries to new rows</a></p>
  
  <p>but I want to do this while keeping all of the data in columns A-V intact. Also note that column W can have up to 40 items that need to be separated.</p>
  
  <p>Thank you very much!</p>