Cross tabulation using C#

Question

Hi All,

I need to create a cross tab using datatable in C#.

Something like this fucntionname(Array datarows,Array datacolumns)

The function should return the cross tabed table, more parameters for missing values would be great

The source datatable can have multiple columns ranging from 1 - N.

following are the tables

http://spreadsheets.google.com/ccc?key=0AqHB594MncmcdHJZZndGektZeDJSanFma0pUUk5kUmc&hl=en

Currently Im doing a dataset count on each cell that is being cross tabed - [for eg:counting each instance {for the first cell} of cat for male and so on -> However I feel this is very resource hungry way of doing it, any better suggestions??!!!!......]

Thanks