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

[Launch_Werx]

Hello,

I am trying to sort an excel sheet by name and unique identifier and then create a new sheet per unique identifier in Studio. I am able to sort by name; however, I am having troubles creating new sheets per unique identifier, or “Squadron”.

Any help is appreciated.

[Launch_Werx]

[Yoichi]

Hi,

Hope the following sample helps you.

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,

[Launch_Werx]

Thank you!