I have an Excel file with the a data table, and it has 4 columns: ID, Month, Location, and Score. I want to sort this table by 2 columns, in the correct order. First, sort the entire table by Location, and then after that, sort it by Month.
I was thinking about using Sort DataTable activity, but it seems to sort only one column. If I use two Sort DataTable activities, the second activity will most likely mess up the sorted datatable by the first activity, and this is not what I want.
I need to apply two kinds of sorting to the table. I will attach an image of the original unsorted datatable, and the sorted datatable. How could I do this?
The left is the original unsorted one. The right is what I want.