Setting missing values to null for sorting

Hi,

Could you please tell me how I can sort columns in ascending order for columns that have missing values. At the moment if I sort like this, all the rows with missing values appear first.

Thanks
Richard