Removes all blank entries from cells. Bear in mind this is not reversible and does not maintain alignment
i.e., if one row has a blank first cell and 5 filled cells, it will have just five members after calling this function.
If the next row has 6 filled cells, it will have six members resulting in a mismatch of the first member of each row.
DO NOT call this before calling RemoveEmptyInnerDimensionFromValueArray(COLUMNS) if you want to remove empty inner columns.
|
In
Exec
|
|
|
Target
Google Sheets Sheet Tab Data Object Reference
|
|
Out
Exec
|