Copy value from above row in excel

[NIVED_NAMBIAR (NIVED N)]

Hi @jenkim

Try this way

1. Use read range to read the excel file and store in dt1

2. 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

value as dt1.Rows(index-1)(1).ToString

In else section do nothing

Hope it helps you

Regards

Nived N

Happy Automation