search

codeice / linqtoexcel

Automatically exported from code.google.com/p/linqtoexcel
0 stars 0 forks source link

LinqToExcel Group by and Sum #111

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
Hi Team,

I have an excel sheet with the below rows and colums,

Name  Type   Value
 x1    a       3
 x2    a       2
 x1    a       4
 x1    b       1
 x2    a       2
 x1    a       3
 x3    b       3

What is the expected output?
 i wanted to group by "Type" and sum "value".
expected as below.
     Name x1    x2    x3
Type
 a        10     4     0
 b         1     0     3

What version of the product are you using?
Ima using LinqToexcel in VS in C#
Please help with above and your help will be appreciated.

Original issue reported on code.google.com by sure05pa...@gmail.com on 29 Sep 2014 at 1:39