Apply this formula in cell E2, and fill down and across. It will put an X in the intersection of a name and a group:

=IF(SUMPRODUCT(--($A$2:$A$2472=E$1),--($B$2:$B$2472=$D2))>=1,"x","")