Comments by Vitaliy Fedorchenko (Top 1 by date)

As alternative to writing custom grouping code you may use NReco PivotData library (free) that can do the same with 1-2 lines of code and provides universal approach for tasks like that (see my answer on StackOverflow linked above).