I have two excel workbooks with data and I want to combine the first column and sort it alphabetically. How would i go about combining the two datatables as well as sorting it?
You can use Merge Data Table to add those datatable values and then, use Sort data table by specifying column index and datatable to sort it.
here’s one sample workflow for your better understanding. —> test.xaml (8.8 KB)
I think you can use Join Data Tables and Sort Data Table to implement your case.
Or you provide two sample table, that someone can make a example for you.