Is it possible to have text as a result in a pivot table? For example, if I
have an employee and a supervisor and I want to link these to their
task/duties. Or maybe I have an employee with multiple jobs, each with a
different duty.

If there isn't an option in a Pivot Table, maybe somebody could recommend
something else. Thanks a lot.