Need guidance regarding VBA

[Arpan135]

I have one excel file where I have to arrange the data based upon the unique ID. Here you can each unique ID has separate role and I need to make it align in a single cell(like down). 

Can you please suggest how to proceed with it.

 

[#2]

@Arpan135 

You don't need VBA for this, a simple formula will doe:

=TEXTJOIN(", ", TRUE, FILTER(Role_Range, ID_Range=Specific_ID, ""))