title: split column values into rows and create a unique record for each id
body: <p>my table is like:</p>
  
  <pre><code>id  name        question            answer      comment
  1    ann        are you happy?      yes         yes, i am happy.
  1    ann        got job?            no          not yet
  2    joe        are you happy?      no          sometimes.
  2    joe        got job?            no          not yet
  3    jim        are you happy?      yes                  
  3    jim        got job?            yes         not yet
  </code></pre>
  
  <p>and i want to convert the table like:</p>
  
  <pre><code>id  name    question1       answr1  comment1            question2   answer2 comment2
  1   ann     are you happy?  yes     yes,i   am  happy.  got job?    no      not yet
  2   joe     are you happy?  no      sometimes.          got job?    no      not yet
  3   jim     are you happy?  yes                         got job?    yes                         
  </code></pre>