Copy value from one column based on condition in other column

Question

Hi Team,

I am looking for help in below scenario.

IDAmount1 1 1 12001 1 2 2 2 2 2 23002

I want to fill in the values in all empty cells corresponding to the ID column. In above scenario, 200 should be copied over to all cells with ID =1.

Expected Output:

IDAmount1200120012001200120012002300230023002300230023002300

I was unable to find a solution in the forum. Request you to kindly guide here with a sample workflow or any supporting links.

Thank You!

binu_acs · Accepted Answer

@ArunAnnaldas1908 One way of doing this with the multi-row tool

Qiu · Accepted Answer

@ArunAnnaldas1908 
We can also try a Join approach.