How to remove empty row in excel for some specific columns

How to remove empty row in excel also pic attached for reference

Please take any column after D in excel to remove empty row


You can use Filter Datatable activity and mention your column for example F->“campaign” and put is not empty

Then you will get all the values wth the campaign which is not empty

Now use Read Range activity to write it back to a new excel

Hope this may help you


1 Like

Hi @sathish_Kumar6

You can try the following query in the ‘Assign’ activity:

yourDt.AsEnumerable.Where(Function(row) row(2).ToString.Trim.Equals(String.Empty) OR row(3).ToString.Trim.Equals(String.Empty)).CopyToDataTable

This query is basically checking for the 3rd and 4th columns here, but you can include all necessary column indices that you want to check.

Hope this helps,
Best Regards.

1 Like

Thank you so much!

1 Like

Thank you so much

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.