Find string , return corresponding row values and concatenate into Cell with commas

[Itolond]

Hi Forum,

Looking for some assistance here

I have a single sheet with a full list of individual with unique identifiers (UID) for each (in rows) some but not all of these individuals are managers, and column N has the managers UID where there are managers ( most rows are blank)

I would like to have formula which i can copy down that looks at the UID (col B) and searches Col N for all matches. grabs strings for column B (the UID) and concatenates them (comma separator) in the formula Cell

The outcome is to identify all the UID's of direct reports for a manager (who obviously has direct reports)

any guides here Can seem to get index/match and concatenate to work for me :-(

[shukla.ankur281190]

Hi Itolond

Can you share a sample spreadsheet once with desired result for getting solution at earliest.

Thanks
Ankur

[Itolond]

attached with comments

your help is appreciated

[shukla.ankur281190]

What is your expected result as I am unable to understand

[Itolond]

the result is to gather all the emails of direct reports of a manger (concatenate) in one cell (in the row with the managers details) separated by a comma.

All users (inc managers have a UID) which is in column A.
The Idea is to search for the UID of the users (Col A) in column F to find which users are linked/report or that UID, grab all the instances of the users email (where there is a match) concatenate and put into the cell (column E) where ters no match - blank