title: How to "invert" data in a CSV-file with an array of values
body: <p>My question is about CSV/Excel data.</p>
  
  <p>I have a huge list in CSV/Excel where I want to "invert" the data from this:</p>
  
  <pre><code>ArticleNO;Reference&lt;br&gt;
  TRX82056-4;428030,426532,422992&lt;br&gt;
  TRX82058-4;428030,426532,422992
  </code></pre>
  
  <p>To this:</p>
  
  <pre><code>Reference,ArticleNO&lt;br&gt;
  428030;TRX82056-4,TRX82058-4&lt;br&gt;
  426532;TRX82056-4,TRX82058-4&lt;br&gt;
  422992;TRX82056-4,TRX82058-4
  </code></pre>
  
  <p>Instead of having the "ArticleNO" as base and the "Reference" as an array of matches, to have the "Reference" as base and the "ArticleNO as an array of matches,</p>
  
  <p>Is there anyone who has a good idea how to acheave this? Excel or Python maybe?</p>
  
  <p>Thank you!</p>