title: Python, transposing a list and writing to a CSV file
body: <p>I need to write into a csv file using python and each iterator item should start in a new line.
  So delimiter I am using is "\n".
  After each list has been written,next list should write from next cell.
  like below:</p>
  
  <pre><code> lol = [[1,2,3],[4,5,6]]
  </code></pre>
  
  <p>The csv will be like:</p>
  
  <pre><code>1 4
  2 5
  3 6
  </code></pre>
  
  <p>What I have tried:</p>
  
  <pre><code>file = open("test.csv", "wb")
  fileWriter = csv.writer(file , delimiter='\n',quotechar='|', quoting=csv.QUOTE_MINIMAL)
  spamWriter.writerow([1,2,3])
  spamWriter = csv.writer(file , delimiter=',',quotechar='|', quoting=csv.QUOTE_MINIMAL)
  spamWriter.writerow([4,5,6])
  file.close()
  </code></pre>
  
  <p>Which results like below:</p>
  
  <pre><code> 1
   2
   3
   4 5 6
  </code></pre>
  
  <p>Using csv module how can I get output like below:</p>
  
  <pre><code> 1 4 
   2 5
   3 6
  </code></pre>
  
  <p>here space means comma in a csv file.</p>
  
  <p>Thanks.</p>