Match two criteria in two columns

Is it possible to match a name with a job when the name is in column and the job in another table row along with the name?

I have attached a sheet as I'm having trouble articulating what i need.

I have a long list of People and then their associated jobs. I need to combine this into a table that has the person's name in the column and an x below their name if they can do that job.

Thanks,
Jason

Another way,

=LET(
  a,FILTER(A2:B100,A2:A100<>""),
  b,SORT(UNIQUE(INDEX(a,,2))),
  c,TRANSPOSE(SORT(UNIQUE(INDEX(a,,1)))),
  d,MAKEARRAY(ROWS(b),COLUMNS(c),LAMBDA(x,y,IFERROR(IF(ROWS(FILTER(a,(INDEX(a,,2)=INDEX(b,x,1))*(INDEX(a,,1)=INDEX(c,1,y))))>0,"x",""),""))),
  VSTACK(HSTACK("",c),HSTACK(b,d))
)

Thank you all for the help

You are welcome.
-----------------------------------
If that takes care of your original question, please click on "Thread Tools" from the menu link above and mark this thread as SOLVED.