Fill Data table empty cell with last filled cell in column

Help Activities
, , ,
2

Hi,

Can you try the following expression?

dt = dt.AsEnumerable.Select(Function(r,i) dt.Clone.LoadDataRow({dt.AsEnumerable.Where(Function(r2,i2) i2<=i andAlso not String.IsNullOrEmpty(r2(0).ToString)).Last.Item(0).Tostring,r(1)},False)).Where(Function(r) not String.IsNullOrEmpty(r(1).ToString)).CopyToDataTable()

Regards,