How to fill the gaps in excel with the previous value

how to fill the gaps in sheet with the previous value

Hi @gantada_Nikitha ,

I could not able to open the attached link. However as I understand your problem is need to fill the empty cells with previous values in a table. if yes below is the solution

write the below code in vb code activity

Dim dr As DataRow
Dim r As Integer
Dim i As Integer

r = 0
For Each dr In dt1.Rows
If (r > 0) Then
For i = 0 To dt1.Columns.Count-1
If (dr(i).ToString = “”) Then
dt1.Rows(r)(i) = dt1.Rows(r-1)(i)
End If
End If

where dt1 is the input table getting through arguments.