Copy value from one column based on condition in other column

[ArunAnnaldas1908]

Hi Team, 

I am looking for help in below scenario. 

ID	Amount
1
1
1
1	200
1
1
2
2
2
2
2
2	300
2

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: 

ID	Amount
1	200
1	200
1	200
1	200
1	200
1	200
2	300
2	300
2	300
2	300
2	300
2	300
2	300

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!

[binuacs · Accepted solution]

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

[Qiu · Accepted solution]

@ArunAnnaldas1908 
We can also try a Join approach.

[ArunAnnaldas1908]

Thank You. The solution worked good. 

[Anand_Parekar]

Thanks this was helpful!