I think I need a pivot table or chart but but not sure...

I need to create a matrix/grid with the following info:

Roles/positions (titles) that my company on boards (hires) such as: RSM, RDMA, MIM, etc.
For each of these roles a series of tasks must be performed in a particular sequence.
Approx 80% of these tasks are universal and apply to ALL roles such as: create network accounts, initiate computer build, schedule product training, etc.

The remaining 20% are role-specific such as assigning access to certain unique software applications/programs, etc.

It would also be great if I could color coordinate tasks to their functional areas such as administration, training, IS, etc.

I have the roles and tasks captured, but don't know how to construct the spreadsheet so that the appropriate tasks fall under the correct roles. I was thinking pivot chart/table but have not been successful in my attempts.

Thanks for any help!

See attached. There are more roles I am dealing with but I made 3 dummy roles and some associagted tasks and permissions. I really appreciate your reply. Any questions let me know. I messed around with grouping some of the tasks, but I don't think that will work because a separate e-mail needs to be generated for each task to a different functional area, so even though something is in the "asset" group, a dozen e-mails might need to be generated.