Column Transpose with Condition on its Cells' Values

Help Studio
21

yes we can modify

1 Like
22

Great !!!

23

Lets assume first col (index 0) holds the grouping info, second col holds the values
give a try on

(From s In dtData.AsEnumerable.Select(Function (x) x(0).toString).Distinct()
Where Not (isNothing(s) OrElse String.IsNullOrEmpty(s))
Let grp = dtData.AsEnumerable.Where(Function (f) f(1).toString.StartsWith(s))
Let grv = grp.Select(Function (v) v(1)).toList
Select Tuple.Create(s, grv)).ToDictionary(Function (t) t.Item1, Function (t) t.Item2)

feel free to replace the col index with the col name

1 Like
24

No Comment !!! :+1:

25

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.