title: Excel: Generate a SQL-Query from huge Excel
body: <p>I have a huge excel with thousands of rows and I need to generate an sql query to insert the data into a sql server database.</p>
  
  <p>The format of the excel is the following</p>
  
  <pre><code>1 | string1 | another string
      string2
      string3
  2 | AAA AAA | ZZZZZZZ
      BB BBBB
      CCCC CC
  </code></pre>
  
  <p>The first column is a row counter, it doesn't matter.
  The second column is a group of strings separated by break-lines
  The third column is a string that has to be associated to each of the strings on column 2.</p>
  
  <p>So I need to generate the following queries:</p>
  
  <pre><code>INSERT INTO SomeTable VALUES ('string1', 'another string')
  INSERT INTO SomeTable VALUES ('string2', 'another string')
  INSERT INTO SomeTable VALUES ('string3', 'another string')
  INSERT INTO SomeTable VALUES ('AAA AAA', 'ZZZZZZZ')
  INSERT INTO SomeTable VALUES ('BB BBBB', 'ZZZZZZZ')
  INSERT INTO SomeTable VALUES ('CCCC CC', 'ZZZZZZZ')
  </code></pre>
  
  <p>Is it clear what I need to do?</p>
  
  <p>Unfortunately my excel habilities are so poor so I can't figure a way to do this.</p>
  
  <p>Any help?</p>
  
  <p>Thank you so much!</p>