Delete blank cells in google sheets

[robert26]

Hey!

This would be a part of larger macro, but I am struggling with one step. I have Google Docs spreadsheet with ~400 columns.
The structure is similar to attached example - all columns have Row A filled, but for the rest of the table there could be 1 or multiple empty cells each row before additional data appears. I want to remove those spaces.

For MS Excel I would just use Find > Go to special > Blanks > Delete.

However no such option exists in Google docs

Does anyone have any brilliant ideas?

Sheet 1 - starting data
Sheet 2 - the result I want

[Haluk]

You can run the function "main" to delete blank cells in columns A ~ F

Change the sheet name "Sheet1" if its different in your original Google Sheet.

Please Login or Register  to view this content.

[Haluk]

You may need a loop in thr function "main" for 400 columns.
But i am away from my computer now....

[robert26]

Thanks! Can you please show how looping would look like for that part? Im quite new to this.

[Haluk]

Delete the previous functions and use these;

Note: Change 10 to 400 or whatever your count of columns is....

Please Login or Register  to view this content.

[robert26]

Thanks. it works, but for i <=2000 script runs for 20 min. Is that normal? at the moment table is like 300x500 cells filled with some blanks inbetween.

[janmorris]

because the cleanup is done by one column after the other, cleaning one column is not the same as cleaning thousands.