title: How do I combine mulitple single columns Lists into a multi column single List?
body: <p>I have the following class:</p>
  
  <pre><code>    public class AuditBatch
  {
      public List&lt;string&gt; Tables { get; set; }
      public List&lt;long&gt; TotalRecords { get; set; }
      public List&lt;int&gt; Index { get; set; }
  </code></pre>
  
  <p>This is then called by another class, and values are added to these lists:</p>
  
  <pre><code>auditBatch.Tables.Add(extractQuery.Category);
  auditBatch.TotalRecords.Add(rowsInFile + totalRowsInFile);
  auditBatch.Index.Add(fileIndex);  
  </code></pre>
  
  <p>I then want to be able add these Lists to a List that takes each of these lists as a column so it would look something like this:</p>
  
  <pre><code>Tables | TotalRecords | FieldIndex
  John      333             1
  Paul      200             4
  Ringo     890             1
  </code></pre>
  
  <p>At a later date I might be interested grouping by FieldIndex and taking the highest TotalRecords Row.</p>
  
  <p>I've followed lots of examples but can't seem to find anything that works.</p>