Sort Datatable by two columns

Hi. I have a table that does not have headers and I have to sort it by Column A (from A6) ascending and by column M (from M6) from A to Z.
I don’t know how many rows I have because data always changes. There also can be empty cells in table.

1 Like

(From x In datatable.AsEnumerable() Order By convert.ToInt32(x(“Column2”)), convert.ToString(x(“Column11”)) Select x).CopyToDataTable



You can easily sort out your data table using sort data table activity.
if you dont know column name, you can also provide column index like 1, 2, 3

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