sort by ascending values with non-blanks on top

[zerob]

can any help me figure out how to sort a column with ascending only with non blank values on top?

= Table.Sort(#"Reordered Columns",{{"Mark", Order.Ascending}})

The table only return blank values on top.

[Zubair_Muhammad]

@zerob 

You can add a supporting custom column and then sort by that column

=if [Column1] = null then Number.PositiveInfinity else [Column1]

[zerob]

Thanks for the reply, but is there a way to sort by just adding a formula? like nonblankvalues..sort.ascending?

The values in my column are alpha numerica so even if I add infinity or null to blank it sorts null in the middle of my values. Sure i can put the values like zzzzzz9999 and it will go to the bottom, but is there a better way to do this?

thanks