Is it possible to change the order on Data Validation?

The data i want to use is something like this:

But data validation show the order from left to right then down. Can the order change to top to bottom then right?

CodePudding user response：

directly in data validation its not possible. you can achieve this with helper column tho.

=SORT(FLATTEN(A:C))