How to assign cells from different columns based on their values

[tagoge]

Hi i have big problem. I tried many times but i dont know how to prepare vba code which help me to to assign value when is the same from one column to another.it means that

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date
[/TD]
[TD]Shipment date
[/TD]
[TD]Product index
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]01/01/2018
[/TD]
[TD]01/01/2018
[/TD]
[TD]W10-1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]02/01/2018
[/TD]
[TD]01/01/2018
[/TD]
[TD]W10-2
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]03/01/2018
[/TD]
[TD]02/01/2018
[/TD]
[TD]W10-1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]and so on
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
after
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date
[/TD]
[TD]Shipment date
[/TD]
[TD]Product index
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]01/01/2018
[/TD]
[TD]01/01/2018
[/TD]
[TD]W10-1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]01/01/2018
[/TD]
[TD]W10-2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]01/02/2018
[/TD]
[TD]01/02/2018
[/TD]
[TD]W10-1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]and so on
[/TD]
[TD]and so on
[/TD]
[TD]and so on
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Thank you

 

[Joe4]

Welcome to the Board!

I think you need to explain the logic to us. It is not apparent from your images without any explanation.