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

[antman2988]

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

Actual Data:

Araiza, Jennifer <tbody> </tbody>	AM Processor <tbody> </tbody>	FS101 <tbody> </tbody>	FS102	AM101	AM112
Araiza, Jennifer <tbody> </tbody>	AM Manager <tbody> </tbody>	FS101 <tbody> </tbody>	FS102	AM101	AM112	AM122
Araiza, Jennifer <tbody> </tbody>	AM Approver <tbody> </tbody>	FS101 <tbody> </tbody>	FS102	AM101	AM122	AM132
Araiza, Jennifer <tbody> </tbody>	AM Maintainer <tbody> </tbody>	FS101 <tbody> </tbody>	FS102	AM101	AM112	AM142
Araiza, Jennifer <tbody> </tbody>	AM Confidential User <tbody> </tbody>	FS101	FS102	AM101	AM112
RESULT
Araiza, Jennifer <tbody> </tbody>	FS101	FS102	AM101	AM112	AM122	AM132	AM142

<tbody>
</tbody>

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.


Any assistance is appreciated!

Thanks,
Anthony Smith

 

[antman2988]

I figured out a way to do it using a few different formulas.