Find matches in one column and combine data from another column

Question

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

geraldo · Answer

@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

Aaron_Bowen · Answer

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 · Answer

@Aaron_Bowen

I believe that the Tile tool can meet your need