I have an Excel spreadsheet with two columns and no headers. The data is not formatted as a table in Excel. Also, it has a dynamic number of rows (rows can be added or deleted over time). For example:
49 aaa 42 bbb 83 ccc 13 ddd 2 eee 8 fff
What I’m trying to do is simply pull the data into a DataTable and then sort the datatable by the first column and then, using a for each loop, display the items in the second column. How can I do this?
(in reality, I’m trying to shuffle the datatable in a random order - so the numbers in col1 are randomly generated when the Excel file opens)