Find matches in one column and combine data from another column

[Aaron_Bowen]

Hi,

I need some help please :) I have a workflow that contains a unique identifier (national Provider Identifier) in one column: 

and another column with a specialty type: 

There are duplicate NPIs in the data with different specialty types. I need a tool or formula to find matches in the column with unique identifiers and combine the values in the specialty types (while also removing duplicate values in that concatenated cell). 

Thanks, 

Aaron 

[binuacs]

@Aaron_Bowen Can you provide the expected result ?

[Aaron_Bowen]

The expected result would be comma separated values in the Specialty Type for matching NPIs: 

[geraldo]

@Aaron_Bowen 

I believe that the Tile tool can meet your need

[Aaron_Bowen]

Hi Geraldo, 

Thanks for replying so quickly. The Tile Tool does exactly what you showed in the picture when I did it with my data (see below):

However, I'm not sure where to go from there. I need the Specialty Type values combined in a single column like this: 

Any idea how to make that happen? 

Thanks, 

Aaron 

[geraldo]

@Aaron_Bowen 

This tool can be helpful.

I noticed that the "," can be the text separator.

You may need to clean up whitespace at the start