Sort mixed type values in column

[Anonymous]

Hi, I have a column like this:

with more than 300 values, numbers, numbers+characters, characters...are mixed...column can change every day because I get it from an sql query. I need to sort column by numerical values to get 1, 1.5, 2, 2.5...in order to sort columns in my matrix vis :

how could it be done?

Thanks!

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.