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 classes, I would like to combine the rows based on the user while keeping all unique values and keeping just one of the repeated values.

Example:

Smith, Bob    AP Approver     Intro    Intro2    Voucher Processing

Smith, Bob    AP Processor     Intro    Intro2    Suppliers

Smith, Bob    AM Processor    Intro    Intro2    Asset Mgmt. Module

Result:

Smith, Bob    Intro    Intro2    Voucher Processing    Suppliers    Asset Mgmt. Module

Note: Their roles do not need to be maintained. I just care about the classes. Also, the information is on the first three sheets. I was trying to figure out how to do it myself but couldn't.

I have attached a workbook. 

Any assistance is appreciated!

Thanks,

Anthony Smith