Column Transpose with Condition on its Cells' Values

[ppr (Peter Preuss)]

@hsendel
we can do it dynamicly with the help of groupBy, dictionary and LINQ

Variables:

Grouping the data by the the first two letters into a dictionary:

retrieving the max length for the longest group:

Preparing the result datatable columnstructure:

Build datatable with first column (ColName: Key), then we do add the other columns:

Finaly we use following LINQ for populating the target DataTable:

• LINQ iterates over the GroupDictionary
• Fills up missing columns by empty values
• Concats exisitng values with filled up values (pra)
• Adds the key info to the rowArray (ra)
• uses the rowarray to add the datarow to dtResult

Input (Similar to your Excel), GroupDictionary and dtResult:

Find starter help here:
GroupBy_1Col_TransposeMembers.xaml (11.8 KB)

Find some further help also here:

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operator [HowTo] Overview Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start…