request for help : pivot table or possible formulas

Hello!
thank you for seeing the thread.
may i ask for your help in my problem?
im trying to present the statements of those who "agreed" to certain persons.
i have to do this to about 4000 people agreeing to 1000 people, is there a faster way? im all out of options.
input:

input.PNG

expected output:

output.PNG

i appreciate all help! thank you in advance!