Error while using merge Data table activity

It would be something like this.

For Each row in myDT

  • If NOT row.Item(“Name”) = “”
    – Assign saveName = row.Item(“Name”).ToString
  • Else
    – Assign row.Item(“Name”) = saveName
    // End For Each

I think that’ll work. Basically if Name has a value you store that value and keep looping. If it doesn’t have a value you assign the previously stored value.

Keep in mind this will only work if the order stays how you have it in the screenshot. If they get mixed up it won’t give you the right output.

This technique doesn’t seems to be working for me as the data is like below shared excel sheet.

Sheet 1 is what is the curret scenario and sheet 2 is what I want.

FF.xlsx (9.4 KB)