[feature suggestions] Remove dispersed cells; sort colums/rows afterwards

[noyannus]

Is it possible to remove cells when part of their rows or columns is not empty?

From

|a| |a|a|
|b|a|b| |
| |b|c|b|
|c|c| |c|

to

|a|a|a|a|
|b|b|b|b|
|c|c|c|b|

, and the same for rows, shifting the cells to the right of empty cells left.

This will be very resource intensive for large spreadsheets, but those who have to process them frequently usually have better means than a manual cleanup. And for the rest of us it would be very useful.

And if you really want to have fun, give us the option to sort each individual column or row after the empties are gone:

From

|a| |c|b|
|c|c|a| |
| |a|b|a|
|b|b| |c|

to

|a|c|c|b|
|c|a|a|a|
|b|b|b|c|

to

|a|a|a|a|
|b|b|b|b|
|c|c|c|b|

There is no good option to do this; for larger numbers of columns or rows; doing it manually is really tedious.