I need some hel.

I have three columns of data in a worksheet. Column A contains the names of
people. Each person's name may appear multiple times in column A depending
on how many roles (responsibilities) that person has. The roles are listed
in column C. Example: Column A may list "Mary" five times if she has five
different Roles listed in Column C. I've added an index in Column B relating
to the role in Column C. Column B contains the text entries "Role_1" through
"Role_32" as needed for each person. If a person has only one role, then
Column B will contain only one entry for that person and the entry would be
"Role_1." But, for "Mary", Column B contains five entries, "Role_1" through
"Role_5", corresponding to the descriptions of Mary's roles in Column C.

Now, I'm trying to set up a separate worksheet in which each person appears
once as a column header and the role names, ranging from Role_1 to Role_32,
are the row headers. In the cells, I want to display the text values from
column C of the first worksheet.

I've worked with vlookup and hlookup. This seems like kind of a nested
lookup function. I have not worked with array functions. Can you help me?