To split the excel sheet alphabetically

Hi all,

I have a excel sheet with a column called names.
I want to split the datatable based on this column alphabetically.

I want to split/divide the column names
Into 3 separate datatable where values starting with Letter A-J is in first datatable
K-R in the second datatable and S-z in the third.

Any ideas?

Thanks in advance!

Hey @Ray_Sha1, give this workflow a try: Sort-DT-Alphabetically.xaml (9.6 KB)

Thanks!

Hi @monsieurrahul ,

Thanks for the reply.
This seems to work but in the new excel sheet I just don’t want to add the column names but other columns as well.

There are atleast 10 other columns along with the column names

Any idea?

Thanks in advance!

@Ray_Sha1, in that use you can pass the row.ItemArray in the ArrayRow property instead of just the row(“Name”).ToString.

Did that.

Thanks again​:relaxed::relaxed:

1 Like

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