How can I delete rows in an excel file if for example column A is empty

[Palaniyappan (Palaniyappan P)]

Hi

There is Another thread with discussion on similar query
Would recommend to have a view on it and see whether it solves ur scenario

How to delete entire Row if a specific column has empty cells

Hello Everyone, I have the following datatabel [1] I need to filter the red marked column. The condition is if the Column has any “Empty” or “Blank” cell then that entire row must be deleted. At the moment i m being able to do it using VB Script. Now the challange is that the table does not always have “Empty” or “Blank” cell, so at that moment the VB Script is throwing error ofcourse. I tried to use the Filter Datatable activity but its only removing the rows based on “Empty”…

Cheers @goncalo.rocha