Delete rows in excel dynamically when column has null value

I have an Excel sheet like this.
How to delete the empty rows.
Row number:2,5,6,9. etc… dynamically (if Column a is null/blank).
I need only the yellow colour highlighted data.
Any inputs?


Have look here:

As you need the opposite use this statement

(From d In dtData.AsEnumerable
Where Not d.ItemArray.Any(Function (x) If(isNothing(x), True, String.IsNullOrWhiteSpace(x.toString.trim)))
Select d).toList


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