using System;

using System.Linq;

using System.Collections.Generic;

​

public class Row

{

    public string StaffName

    {

        get;

        set;

    }

​

    public string ProjectName

    {

        get;

        set;

    }

​

    public string Month

    {

        get;

        set;

    }

​

    public int Weeks

    {

        get;

        set;

    }

}

​

public class Program

{

    public static void Main()

    {

        var data = new List<Row>

        {

        new Row

        {

        Month = "January", ProjectName = "Project1", StaffName = "Venkat", Weeks = 4

        }

​

        , new Row

        {

        Month = "February", ProjectName = "Project1", StaffName = "Venkat", Weeks = 2

        }

​

        , new Row

        {

        Month = "January", ProjectName = "Project2", StaffName = "Venkat", Weeks = 3

        }

​

        , new Row

        {

        Month = "March", ProjectName = "Project1", StaffName = "Kumar", Weeks = 5

        }

​

        , new Row

        {

        Month = "December", ProjectName = "Project4", StaffName = "Venkat", Weeks = 3

        }

        }

​

        ;

        var res = data.GroupBy(x => new

        {

        x.StaffName, x.ProjectName

        }

​

        ).Select(x => new

        {

        StaffName = x.Key.StaffName, ProjectName = x.Key.ProjectName, Jan = x.Where(y => y.Month == "January").Sum(y => y.Weeks), Feb = x.Where(y => y.Month == "February").Sum(y => y.Weeks), Mar = x.Where(y => y.Month == "March").Sum(y => y.Weeks), Dec = x.Where(y => y.Month == "December").Sum(y => y.Weeks), //Add more month here

Total = x.Sum(y => y.Weeks)}

​

        );

        foreach (var item in res)

        {

            Console.WriteLine("{0} - {1} - {2} - {3} - {4} - {5} - {6}", item.StaffName, item.ProjectName, item.Jan, item.Feb, item.Mar, item.Dec, item.Dec);

        }

    }

}