How to replace value in datatable if one column is blank

Hi There,
I have any excel sheet with two columns Parent Customer Name and Bill to customer.Some times Parent Customer Name will be empty.
If Parent Customer Name is empty, i have to use the Bill to customer in the place of Parent customer name.
how to achieve this
to this.

@Vishwanth_Raya Read your excel file and

  1. use for each data row loop with input datatable from read operation.
    a) with if activity check whether first column value for that row is empty or not. If empty do like below with assign activity. Considering row is for variable.
    if not empty don’t do anything.
  2. After for the same datatable again back to same excel or different excel. you will get required result.
1 Like