Manipulating data table

ebi

I am working on ASP .NET. I have data set which retrieves data from SQL DB. This data set contains one big data table with many columns.
Now my question is:
1)How to split this table into many tables. New tables contain only two columns. First column is first column of big table and second column is each column from big table). If there are 4 columns in big table, 4small tables should be created dynamically.
2)This small table with two columns looks like this.
date roll_NO
1-1-11 343
1-2-11 343
1-3-11 564
1-4-11 764
.
.
.
.
so on..
This table has to be modified in the following format.

roll_NO 1-1-11 1-2-11 1-3-11 1-4-11 .......

343 yes yes No No ............
564 No No Yes No .............
764 No No No Yes ............
.
.
.
.
.
.

Please help me. Im new to this datatable..
Thanks in advance......:)