title: Convert CSV file with values spareted in comma to multi columns CSV file
body: <p>I want to create a small program to convert a CSV file with one column containing values separated by comma, to CSV file containing multiple columns with one value:</p>
  
  <p>input file:</p>
  
  <p><a href="https://i.stack.imgur.com/PX9JL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PX9JL.png" alt="input file"></a></p>
  
  <p>output file:</p>
  
  <p><a href="https://i.stack.imgur.com/gJcOB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gJcOB.png" alt="output file"></a></p>
  
  <p>Therefor I write this code:</p>
  
  <pre><code>my_string1 = 'A,B,C,D,E'
  my_string2 = 'A,B,C,D,E'
  my_string3 = 'A,B,C,D,E'
  my_list1 = my_string1.split(",")
  my_list2 = my_string2.split(",")
  my_list3 = my_string3.split(",")
  path = 'C:\Dokumente\\n_1.csv'
  rows = zip(my_list1,my_list2,my_list3)
  with open(path, "wb") as csv_file:
      writer = csv.writer(csv_file, delimiter=',')
      for row in rows:
          for column in row:
              writer.writerow('%s;' % column)
  </code></pre>
  
  <p>But the problem is that it writes all the values in one Column.</p>
  
  <p>I want to write column by column and then I want to move to second row to write again?</p>
  
  <p>I work with Eclipse Oxy with PyDev and Python 2.7</p>