title: Excel, split up comma separated values
body: <p>I have an Excel sheet with 2 columns.</p>
  
  <p>Column1 contains values like:<br><br></p>
  
  <blockquote>
    <p>10969<br>
    11284<br>
    1222<br>
    1227<br>
    12669<br>
    12670<br>
    12671<br>
    12672</p>
  </blockquote>
  
  <p>Column2 contains comma separated values like this:<br><br></p>
  
  <blockquote>
    <p>601010,6010,40,4010<br>
    601010,6010,40,4010<br>
    40,4010,6010,601010<br>
    40,4010,6010,601010<br>
    40,4010,6010,601010<br>
    40,4010,6010,601010<br>
    40,4010,6010,601010<br>
    40,4010,6010,601010</p>
  </blockquote>
  
  <p>I need this split up differently, so instead of having column2 commaseparated, I need 1 row for each value i column 2
  Column1 should use the same value for each string, so you get 4 rows with the same number in column1 and different numbers in column2 </p>
  
  <p>An example using the data from above </p>
  
  <p>Column1 <br><br></p>
  
  <blockquote>
    <p>10969<br>
    10969<br>
    10969<br>
    10969<br>
    11284<br>
    11284<br>
    11284<br>
    11284<br><br></p>
  </blockquote>
  
  <p>Column2<br><br></p>
  
  <blockquote>
    <p>601010<br>
    6010<br>
    40<br>
    4010<br>
    601010<br>
    6010<br>
    40<br>
    4010</p>
  </blockquote>
  
  <p>It is not the same values everytime, and there is more than 1000 lines, so its a big task to do it manually. 
  As far as I can see this is not possible with "standard Excel", But maybe with VBA? </p>
  
  <p>I hope someone can point me in the right direction. </p>
  
  <p>Regards 
  Martin  </p>