How to keep data and the blank rows between data

@Suastrian_Dika ,

In that case, Maybe you could check the below :

DT = DT.AsEnumerable.Skipwhile(Function(x)String.IsNullOrWhiteSpace(x(0).ToString)).CopyToDatatable

DT = DT.AsEnumerable.Reverse.Skipwhile(Function(x)String.IsNullOrWhiteSpace(x(0).ToString)).Reverse.CopyToDatatable

Debug Panel :

1 Like