Rearrange Table Data using Linq

Question

I have data in the following format:

(Table: Hours)
{ Date = "21/04/2008", Person = Sally, Hours= 3 }
{ Date = "21/04/2008", Person = Sam, Hours = 15 }
{ Date = "22/04/2008", Person = Sam, Hours = 8 }
{ Date = "22/04/2008", Person = Sally, Hours = 9 }

Datatypes: Date = Date, Person = String, Hours = Integer

Using LINQ I would like to select it into this format:

{ Date = "21/04/2008", Sam = 15, Sally = 3 }
{ Date = "22/04/2008", Sam = 8, Sally = 9 }

Datatypes: Date = Date, Sam = Integer, Sally = Integer

Is this possible?

Answer 1

from d in data
group d by d.Date into g
select new {Date = g.Key, People = g.Select(gg=>new{Person = gg.Person, Hours = gg.Hours})}

This will give you the data, then it's just formatting to display properly.