title: Storing Multiple Values in an Array into Excel using Pandas
body: <p>I'm having issues with writing values in an Array into excel column. At the moment I can only print the first data set within the array meaning:</p>
  
  <p>within Excel:</p>
  
  <p>COL:A
  Mazda3</p>
  
  <p>COL:B
  Civic</p>
  
  <p>COL:C
  Corolla      </p>
  
  <p>COL:D
  Altima</p>
  
  <pre><code>      tmpList.extend([mazda, honda, Toyota, Nissan])
        df = pd.DataFrame(tmpList)
        df = df.transpose()
        xlsfile = 'pandle.xlsx'
        writer = pd.ExcelWriter(xlsfile, engine='xlsxwriter')
        df.to_excel(writer, sheet_name="Sheet1",startrow=1, startcol=1, header=False, index=False)
        writer.save()
  </code></pre>
  
  <p>Ideally I want:</p>
  
  <p>COL:A
  Mazda3, CX7, CX5</p>
  
  <p>COL:B
  Civic, Accord, Pilot</p>
  
  <p>COL:C
  Corolla, Camry, Sienna</p>
  
  <p>COL:D
  Altima, Pathfinder, Maxima</p>
  
  <p>//EDIT</p>
  
  <p>So i'm able to write multiple data set, but it's the inverse, it's printing everything by column and not row as I would prefer.</p>
  
  <pre><code>xlsfile = 'pandle2.xlsx'
  writer = pd.ExcelWriter(xlsfile, engine='xlsxwriter')
  #df = pd.DataFrame(mylist, columns=['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I'])
  df = pd.DataFrame(mylist, columns=['1A', '2B', '3C', '4D', '5E', '6F', '7G', '8H', '9I'])
  df = df.transpose()
  df.to_excel(writer, sheet_name="Sheet1",startrow=1, startcol=1, header=False, index=False)
  writer.save()
  </code></pre>