How to replace empty value with respective of upper row value in datatable

[ashokkarale]

@Nisha_K21,

Follow this thread,

Fill the blank cells in excel with the value above

@SunnyJha Dim previousvalue As String For Each r As datarow In dt.AsEnumerable If r("ColumnName").ToString.Equals("") Or String.IsNullOrEmpty(r("ColumnName").ToString) Then r("ColumnName")=previousvalue Else previousvalue=r("ColumnName").ToString End If Next Use this in invoke code activity inplace of ColumnName provide your columnName [image]