Macro that merges duplicate rows based on unique values - Need to edit current code

Hiya,

I was able to locate a macro that does exactly what I need; however, I need to make a slight change to the but I have limited vba knowledge and am hoping someone can help me.

I have a spreadsheet that lists employees and their certifications. If an employee has multiple, then they will show up on as many rows as they have certifications.

The macro I have merges them into one row with a line break, but only the first column's unique value has been merged while the other columns containing their own unique values are duplicated when I want them to show up only once. Example: Jane Doe shows up 2 times on the report. Her name should only show up once on the row, not 2 times with a line break.

Here is the code. I have also attached an example of what I need. Because the attachment is a simpler version of the actual report, is it possible to specify which rows have the unique values and which ones don't? Any help is appreciated.

Please Login or Register  to view this content.

Change this line

Please Login or Register  to view this content.

INTO

Please Login or Register  to view this content.

Oh wow, that was so simple. Thanks so much! That did exactly what I needed it to do.

I've also tested it with more columns and it works flawlessly when I increase it by the number of columns I need to show only once