How to use query to generate the result with descending order-CodePudding

Home > Back-end > How to use query to generate the result with descending order

How to use query to generate the result with descending order

Time：08-30

Hi I would like to generate the result with descending order.

is it possible to use Query achieve this result? or is there alternative way ?

Thank you

CodePudding user response：

use:

=INDEX(QUERY(SPLIT(FLATTEN(A2:A&"×"&B1:D1&"×"&B2:D), "×"), 
 "where Col3 is not null order by Col3 desc", ))