Forum Discussion
Need guidance regarding VBA
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 pleas...
You don't need VBA for this, a simple formula will doe:
=TEXTJOIN(", ", TRUE, FILTER(Role_Range, ID_Range=Specific_ID, ""))