How to merge mutiple tables into one, with same schema and column names
<p>I have 3 collection datatable that shows in this below</p>

<pre><code>Month: January
ID     NAME       Absent
001    John       3
002    Travis     0

Month: February
ID     NAME       Absent
001    John       18
002    Travis     14

Month: March
ID     NAME       Absent
001    John       10
002    Travis     5
</code></pre>

<p><strong>Before</strong>, I have used to <code>merge</code> DataTable</p>

<pre><code>dataTable.merge(dataTable2);
</code></pre>

<p>The result is like this:</p>

<pre><code>ID     NAME       Absent
001    John       3
002    Travis     0
001    John       18
002    Travis     14
001    John       10
002    Travis     5

dataTable.Merge(dataTableTemp);
GridView.DataSource = dataTable;
GridView.DataBind();
</code></pre>

<p><strong>But, I want to create like this</strong> (we say: custom GridView):</p>

<pre><code>               Jan      Feb     Mar    Apr
ID    NAME     Absent   Absent  Absent Absent
001   John     3        18      10
002   Travis   0        14      5
</code></pre>

<p>How to add/merge every month in the right side of table before, so if I add next month it will appear in the right side of table before..</p>

<p>How to create this:??? Is there any method of function or tools that I can use??</p>

<p>Thanks for any help..</p>
