Want Fill blank cell values with left cell values if condition matches

[amittheexcel]

Hi,

I have below scenario, I want to fill Clean data column with Source data if clean column do not have values only if first column data is matching after source and Clean.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Source_Account_Name[/TD]
[TD]Clean_Account_Name[/TD]
[/TR]
[TR]
[TD]Amit Chavan[/TD]
[TD]Amit Chavan[/TD]
[/TR]
[TR]
[TD]Amit Chavan[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Amit Chavan A[/TD]
[TD]Amit Chavan A[/TD]
[/TR]
[TR]
[TD]Amit Chavan A[/TD]
[TD]Amit Chavan A[/TD]
[/TR]
[TR]
[TD]Amit Chavan[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Amit Chavan[/TD]
[TD]Amit Chavan A[/TD]
[/TR]
</tbody>[/TABLE]

 

[Kaper]

What is expected output in : Clean_Account_Name

is it:
Amit Chavan
Amit Chavan
Amit Chavan A
Amit Chavan A

Amit Chavan A

So second row filled with left column, 5th left empty because in first column row 4 and 5 values are different