title: Create Columns of Data Instead of Rows
body: <p>I would like to insert my data into Excel in columns rather than in rows, like so:</p>
  
  <pre><code> ---------------
  | Name1 | Name2 |
  | Qty1  | Qty2  |
  | Qtys1 | Qtys2 |
  | Per1  | Per2  |
  | Old1  | Old2  |
   ---------------
  </code></pre>
  
  <p>This is what I currently have: </p>
  
  <pre><code>        using (ExcelPackage excel = new ExcelPackage())
          {
              ExcelWorksheet ws;
  
              ws = excel.Workbook.Worksheets.Add("Chart");
  
              var table = ws.Cells["B4"].LoadFromCollection(
                  dmr,
                  false,
                  OfficeOpenXml.Table.TableStyles.Light15,
                  BindingFlags.Public,
                  new MemberInfo[]
                  {
                      typeof(DMR).GetProperty("Name"),
                      typeof(DMR).GetProperty("Qty"),
                      typeof(DMR).GetProperty("Qtys"),
                      typeof(DMR).GetProperty("Per"),
                      typeof(DMR).GetProperty("Old")
                  });
  </code></pre>
  
  <p>This currently displays my data like:</p>
  
  <pre><code> ------------------------------------
  | Name1 | Qty1 | Qtys1 | Per1 | Old1 |
  | Name2 | Qty2 | Qtys2 | Per2 | Old2 |
   ------------------------------------
  </code></pre>
  
  <p>Is there a setting where you tell it to do rows rather than columns, or is additional code needed?</p>