Sorting Excel Sheet by Rows and Creating New Sheets Per Unique Value

Help Studio
, ,
3

Hi,

Hope the following sample helps you.

image
image1013×1342 34.7 KB 

dict =dt.AsEnumerable.OrderBy(Function(r) r("Name").ToString).ThenBy(Function(r) r("Squadron").ToString).GroupBy(Function(r) r("Squadron").ToString).ToDictionary(Function(g) g.Key,Function(g) g.CopyToDataTable)

Sample20221122-3.zip (10.4 KB)

Regards,