Removing blank cells

Hi all,


I have a large dataset (>700k entries) and have modified an excel table, however when I try to write the table out after all my processing it goes beyond the excel column limit of 16,000. This appears to be because the way the columns have to append as I don't want to replace the data in the columns. Is there any way to remove blank cells like in excel where you select all blank cells, hit F5 select by Blank, delete the cells and shift the other cells left to align correctly?

I have tried numerous methods and cannot get anything to work as it will not produce the output as it keeps throwing an error of column limits.


Hi I do not fully understand what do you want, it is like shifting the cells to the left? if not you can see this post:

I recommend you to include a table as an example.

Best regards