title: Best way to CSV output a vertical list in a horizontal list
body: <p>Python newbie here. I've used XPath to extract some data from a website which gives me a list in a list that looks like this:</p>
  <p><code>[['1','2','3'],['4','','6'],['7','8','9']]</code></p>
  <p>Currently, when I export this to CSV, each of the 'inner' lists is displayed in a single cell like:</p>
  <p><em>Cell A1</em> <code>['1', '2', '3']</code>) <em>Cell B1</em> <code>['4', '', '6']</code> <em>Cell C1</em> <code>['7', '8', '9']</code></p>
  <p>which means I would have to remove the unwanted brackets and quotes, Text-to-Columns and transpose to get what I want, which is this:</p>
  <pre><code>1,4,7
  2,,8
  3,6,9
  </code></pre>
  <p>What can I do/use to do this?</p>