title: Pandas swap multi rows to columns
body: <p>Does anyone know how to transpose pandas dataframe, I have dataset like that:</p>
  
  <pre><code># 99564, Noam
  Hop Company LLC, 10503 Cher rd
  (123) 456-7890, Motor SR 5032
  # 99843, Noam
  Hop Prods,  902010 Rogg rd
  (123) 456-7890, Ed CA 3534
  # 99223, Noam
  Skyline LLC,    12795 Rodf Road
  (123) 456-7890, Sats Road 3922
  </code></pre>
  
  <p>And I want to transform it to this:</p>
  
  <pre><code># 99564, Noam, Hop Company LLC, 10503 Cher rd,(123) 456-7890,   Motor SR 5032
  # 99843, Noam, Hop Prods, 902010 Rogg rd, (123) 456-7890,   Ed CA 3534
  # 99223, Noam, Skyline LLC, 12795 Rodf Road, (123) 456-7890,    Sats Road 3922
  </code></pre>
  
  <p>Can anyone help me with directions on how I can do it?</p>
  
  <p>Thanks!</p>