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
Bookmarks