Here below is a data table:

Sort in ascending order:

=spl("=?.sort()",A1:A10)

Sort in descending order:

=spl("=?.sort(~:-1)",A1:A10)