title: Converting columns to rows and giving them a number
body: <p>I have a data frame with this format:</p>
  
  <pre><code>df
  name,status,text
  stock1,open,text1 
  stock1,closed,text something here
  </code></pre>
  
  <p>and I would like to convert it like this:</p>
  
  <pre><code>name,status1,status2,text1,text2
  stock1,open,closed,text1,text something here
  </code></pre>
  
  <p>How can I convert its columns to rows without know the exact number of columns?</p>