title: Create new row for every single value in column
body: <p>I have the following problem: I have an excel spreadsheet in which there are ids (websites) in one column and the languages in another, e.g. </p>
  
  <p>ID           | Languages</p>
  
  <p>20              English, Italian, German</p>
  
  <p>21              Russian<br>
  22              Spanish, Czech</p>
  
  <p>Now I need to create a new row for every language that a certain ID has and match these languages to a language code, so that I can import the result into a database:</p>
  
  <p>ID | Language Code</p>
  
  <p>20     EN</p>
  
  <p>20     IT</p>
  
  <p>20     DE</p>
  
  <p>21     RU</p>
  
  <p>22     ES</p>
  
  <p>22     CZ</p>
  
  <p>I got another table with the matching language/language code data, too.</p>
  
  <p>How can i transform my spreadsheet into that format? I don't want to type in the languages for 1000+ websites by hand...</p>
  
  <p>Thanks in advance!!</p>