Ok, we have a Dataset which contains a table full of data that was populated form multiple text files.

Now we need to take that table and in some way group it and sort it into another datatable for summary information.

Any ideas on how to achieve this?

.Select does not like Group By syntax, but it does have a sort parameter, so that will probably do fine for the order by part. But still, the group by doesnt seem possible.