How to Merge Rows Based on Cell Value While Keeping Unique Values and Keeping One Repeated Value

Hello,   I have a workbook that contains classes a person must take based on their roles in a system (job duties). Because each roles requires certain classes and all of the roles have repeated cla...