Your requirement is not clear. Please explain properly.
Actually your logic differs from picture. According to your statement we have to apply 'Duplicate' to both rows to vendor 11. Pls correct my if i am wrong.
The excel table yes, however the text table not. It arises a good question which i have highlighted.
So, should it looks like this?
Vendor Task A Task B Task C Task D 11 zzz erwe sfs 1 Duplicate 11 zzz erwe sfs 1 Dublicate 22 zzz erwe sfs 3 Duplicate 22 hhh sdfsd hghfh 4 33 hhh sdfsd hghfh 4
I think this is not explained well by myself and therefore closing the points.
will try and do better.