title: Split one column csv data into multiple columns by number of rows
body: <p>I'm new on this site, hope I'm doing my question properly and on the right side, if not, please any tip will be appreciated.</p>
  
  <p>Just need some guidance with a problem.</p>
  
  <p>I've a csv file like this:</p>
  
  <pre class="lang-none prettyprint-override"><code>| Column1|
  ----------
  abc
  def
  ghi
  12,34
  32,67
  jkl
  mno
  pqr
  28,34
  98,67
  </code></pre>
  
  <p>(really bad file)</p>
  
  <p>And I want to transform into this kind of csv:</p>
  
  <pre class="lang-none prettyprint-override"><code>Something1 | Something2 | Something3 | Something4 | Something5
  ---------------------------------------------------------------
     abc     |    def     |     ghi    |    12,34   |    32,67
     jkl     |    mno     |     pqr    |    28,34   |    98,67
  </code></pre>
  
  <p>There're a total of 15 types of data on 15 consecutive rows on variable number of repeat times and I need to split'em into 15 columns in a new csv file.</p>
  
  <p>My first tought was making a bash script with a function to count lines and split the data by the number of line into a new csv file but I realized the fact maybe it's better to do it using another way or use some pythonic way (with pandas and numpy ) or a PhP webservice (<code>fopen</code> and exploding data or something like that) because this is not going to be the last time I get that kind of trash csv file...</p>
  
  <p>But I need some guidance to start with.</p>
  
  <p>Some help will be kindly appreciated.</p>