title: splitting rows in Redshift
body: <p>In my table the data is as below:</p>
  
  <pre><code>col1    col2    col3    col4
  A1      A2      A3      4
  B1      B2      B3      3   
  C1      C2      C3      1
  </code></pre>
  
  <p>I need the output as below:</p>
  
  <pre><code>col1    col2    col3    col4
  A1      A2      A3      1
  A1      A2      A3      2
  A1      A2      A3      3
  A1      A2      A3      4
  B1      B2      B3      1   
  B1      B2      B3      2   
  B1      B2      B3      3   
  C1      C2      C3      1
  </code></pre>
  
  <p>Im using Redshift DB.</p>