Use read range to read the excel file and store in dt1
Use for each row to loop through each row of dt1
Inside the for each row do the following, create a variable in the index property section let’s say index of for each row which store the row index of each rows through which we are iterating.
a. Put an if Condition with condition as row(“BrandName”).ToString.Equals(" ")
if the above condition is true
Then
Use write cell activitiy to write the value at cell : “B”+(index+2).ToString
@jenkim - 1. Read the sheet and save it datatable called dt
2. For Each row of Dt
2.1 If Condition = row(“Brand Name”).ToString=Nothing
2.2 Assign row(“Brand Name”) = dt.Rows(dt.Rows.IndexOf(row)-1)(“Brand Name”).ToString
Outside of For each Loop . Write Range = Datatable => Dt to the same sheet