Compress the data table against common ID

We assume

  • that excel data is read in within a datatable
  • ID column will be the first column

In general we would do:

  • grouping the data
  • processing the group members and flatten the columns, by catching on non-blanks

Grouping the data: (Non-LINQ, LINQ)

Group Member Processing

  • Essential or with LINQ