Things of that kind aren’t easy. Spreadsheets aren’t actually made for them.
SELECT DISTINCT Field FROM Table WHERE Condition SORT … is a typical SQL statement. Similar constructs are not available when using a spreadsheet.
To additionally complicate the situation you have organised a range containing data of same nature (otherwise listing and sorting them would be senseless) in a 2D-array. (This will not occur using a database.)
We can divide the task in 3 parts:
Reorganise the 2D-array into one column
Sort the entries of that column
Only collect the distinct items now (not changing the sort)
This to do by an apparatus of formulae requres some effort.
You may study the attached example if interested. To actually use such an apparatus of formulae additional measures may be required.Dev2D_1D_SortSelectDistinct001.ods