Excel Formula to list names in a row without duplicates & if cell is left blank

[Fladave]

I need a formula that will list all of the names working each post excluding duplicates and blank cells. Here is what the excel row looks like.

E 3 F3 G3 H3 I3 J3 K3 L3 M3
Team Lead Post 1 Post 2 Post 3 Post 4 Post 5/Adm Asst Specialist Assigned if No AA on Duty End of Shift Report Employees on Duty
Anes Mary Seless Widua S. Creedon Howell S. Creedon S. Creedon Anes, Mary, Seless, Widua, S. Creedon
(Want list to show as above)

Thanks for the assistance & hope this clarifies more what I am seeking.

[AliGW]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new, I have done it for you this time.)

[Fladave]

I hope I clarified the info and format that is required.

Thank you

[JeteMc]

It may help if you upload a file that shows the data as it appears originally (input) and the data as you would like it to appear (output). In that way someone may be able to write formulas/code that will automate the transformation.
To upload a file follow the instructions listed in the banner at the top of the page.
Let us know if you have any questions.

[Fladave]

I have attached file, hope this explains better what I am seeking.

Column L have the following listed names from Posts 1 to 4. I don't want duplicate names or blanks showing.

If any other info is required please let me know.

Thanks again.

[JeteMc]

The following proposal adds helper cells, which may be moved and/or hidden for aesthetic purposes, to the end of each row.
The helper cells are populated using: =IF(COUNTIFS($D3:D3,D3)=1,D3,"")
Column L may then be populated using: =N3&IF(O3<>"",","&O3,"")&IF(P3<>"",","&P3,"")&IF(Q3<>"",","&Q3,"")&IF(R3<>"",","&R3,"")&IF(S3<>"",","&S3,"")&IF(T3<>"",","&T3,"")&IF(U3<>"",","&U3,"")
Let us know if you have any questions.