you will need +1 column to generate sorting sequence used in =QUERY which will return your data
assuming your dataset somehow looks like:
paste this formula in cell F1:
=ARRAYFORMULA(IF(LEN(A:A&B:B&C:C&D:D&E:E),
MMULT(--(LEN(A:E)>0),
TRANSPOSE(SIGN(COLUMN(A1:E1)))),
IFERROR(1/0)))
and then paste this formula wherever you need to:
=QUERY(A1:F,"select A, B, C, D, E where F is not null order by F desc")
if overall visual requires so, you can easily hide the whole F column:
