using System;

using System.Collections.Generic;

using System.Linq;

​

public class Program

{

    public static void Main()

    {   

        var test = new List<Sample>();

        test.Add(new Sample{ID=1,Name="record 1",Status="Outstanding"});

        test.Add(new Sample{ID=2,Name="record 2",Status="Outstanding"});

        test.Add(new Sample{ID=3,Name="record 3",Status="Aging"});

        test.Add(new Sample{ID=4,Name="record 4",Status="Outstanding"});

        test.Add(new Sample{ID=5,Name="record 5",Status="Outstanding"});

        test.Add(new Sample{ID=6,Name="record 6",Status="Aging"});

        var result = from row in  test

                            group row by "Count" into g

                            where g.FirstOrDefault() != null

                            select new

                    {

                            //Status = g.Key,

                            Outstanding = g.Where(C => C.Status == "Outstanding").Count(),

                            Aging = g.Where(C => C.Status == "Aging").Count()

                    };

        Console.WriteLine("Outstanding"+"   "+"Aging");

        foreach(var item in result)

        {

            Console.WriteLine(" "+item.Outstanding+"            "+item.Aging);

        }

​

    }   

}

​

public class Sample

{

    public int ID {get;set;}

    public string Name {get;set;}

    public string Status {get; set;}

}