How to move lines so that they are together after filtered

soyoonmoon

Hello! I created an automation so that all the rows other than rows with column X's value = Y. Now, all the lines are apart from each other because a lot of the rows have been deleted in between. Is there a command line or something in automation that brings all these rows together so that they are right below each other?

Hope I'm making sense - thanks in advance

DavidMMM

If you sort (by any way you want) after deleting rows in the middle, the empty rows will fall off because they'll be punted to the bottom of the list.

Disable the filter (you can't sort with a filter on), right-click on a column header, and click Sort rows.