Update last Row value in the first row for only duplicate value set

Hi @Garyy
Check out this

I hope it helps!!