In my sheet, there are 5 columns of data. Some rows are fully filled and some rows have some empty cells. Now I want to sort my sheet from most-filled row to least-filled row. How can I do it?
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:
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"; 0)
if overall visual requires so, you can easily hide the whole F column: