Shift Left for rows starting with empty columns

[Admin]

That sounds like a good solution. In future we might add a transform to move cells to fill empty spaces. It depends if there is enough demand for it.