Hello @dtuna!
Unfortunately columns of tables in retool only have two default sorting options, ascending and descending.
If all the data is strings it will compare their values and order the rows accordingly. If this sorting does not have the behavior you want (you described for the text chars to be placed separately from the numbers, which you want in order with themselves) you will have to use some custom javascript in a Javascript Query block to order the array of row data to be what you want 
There are lots of resources online about custom sorting algorithms, here is a useful link I found for sorting between strings and numbers.
Once you get the sorting behavior that you want, you can apply that table data on user click!