Pivot data using LINQ

by

I’m not saying it is a great way to pivot – but it is a pivot…

    // sample data
    var data = new[] {
        new { Foo = 1, Bar = "Don Smith"},
        new { Foo = 1, Bar = "Mike Jones"},
        new { Foo = 1, Bar = "James Ray"},
        new { Foo = 2, Bar = "Tom Rizzo"},
        new { Foo = 2, Bar = "Alex Homes"},
        new { Foo = 3, Bar = "Andy Bates"},
    };
    // group into columns, and select the rows per column
    var grps = from d in data
              group d by d.Foo
              into grp
              select new {
                  Foo = grp.Key,
                  Bars = grp.Select(d2 => d2.Bar).ToArray()
              };

    // find the total number of (data) rows
    int rows = grps.Max(grp => grp.Bars.Length);

    // output columns
    foreach (var grp in grps) {
        Console.Write(grp.Foo + "\t");
    }
    Console.WriteLine();
    // output data
    for (int i = 0; i < rows; i++) {
        foreach (var grp in grps) {
            Console.Write((i < grp.Bars.Length ? grp.Bars[i] : null) + "\t");
        }
        Console.WriteLine();
    }

More Related Contents:

  1. Rotate – Transposing a List using LINQ C#
  2. Simultaneous equations in C# LINQ [closed]
  3. Get All instead of FirstOrDefault
  4. How to write this nested foreach loop query in LINQ?
  5. Group by in LINQ
  6. Linq: GroupBy, Sum and Count
  7. LINQ to Entities does not recognize the method ‘System.String ToString()’ method, and this method cannot be translated into a store expression
  8. Find an item in a list by LINQ
  9. Alphanumeric sorting using LINQ
  10. XElement namespaces (How to?)
  11. Row_number over (Partition by xxx) in Linq?
  12. LINQ Grouping dynamically
  13. Mutating the expression tree of a predicate to target another type
  14. Linq list of lists to single list
  15. LINQ Where Ignore Accentuation and Case
  16. Edit specific Element in XDocument
  17. ILookup vs. IGrouping
  18. Enumerating Collections that are not inherently IEnumerable?
  19. Convert anonymous type to class
  20. Comparing 2 objects and retrieve a list of fields with different values
  21. C# Linq where clause as a variable
  22. Find if listA contains any elements not in listB
  23. Find all child controls of specific type using Enumerable.OfType() or LINQ
  24. How to merge a list of lists with same type of items to a single list of items?
  25. Split an IEnumerable into fixed-sized chunks (return an IEnumerable where the inner sequences are of fixed length) [duplicate]
  26. Remove item from list based on condition
  27. Select multiple fields group by and sum
  28. Linq – Top value from each group
  29. C# Searching for files and folders except in certain folders
  30. What is the difference between LINQ ToDictionary and ToLookup

Leave a Comment