Welcome to Forum
Maybe or Not you are expecting a LINQ stateme t that is doing the complete transponation including Datatable structure creation Handling as one Statement.
Catching the columns, transponation and returning IT as a list of object() can bei done with Linq quite pretty. But structure creation, row additional is stressing the Query Nature of LINQ
I really Like LINQ and Work a Lot with IT. but in some cases IT IS better to Setup hybrid approaches. Combine activities with Linq Statements or use only activities
There are some activities as one is mentioned by @supermanPunch. Another from Our friend @Lahiru.Fernando Here
Let me know If you are Interessed on a hybrid approach, so i can Work Out an example for you