Nested 'For Each Row' Loop

[ppr (Peter Preuss)]

@pboleszc

As @Dave mentioned there is the concat trick even used within a groupBy or we constructing 4 keys by using the AND Concatenation (I did here,as other tricks are less easy to read/follow, also when it is posible).

find demo XAML here:
SplitGroups_4Col_IntoDT.xaml (9.3 KB)

Kindly note:

• do rewire the Excel paths as by your environment
• it is writing in one output excel into different sheets, but you can easy modify
• ensure following: AsEnumerable is not a member of 'System.Data.Datatable' - #2 by loginerror