How to Transpose if duplicates

Wow, that's a really impressive formula. I'm going to have to spend some more time with it to fully understand it. I think it's close but I can't seem to modify it to make it work the way I need it to. I attached a much clearer example, using names.

Since I couldn't seem to find a solution anywhere for this, I hope that your effort is useful to more users than just me. Thanks again.