https://docs.google.com/spreadsheets/d/1q6iNB7V8_pvR6qQBLDolU9xU4pbj8M3NAPOu5TFFrPc/edit#gid=185521600

In the attached spreadsheet, I have a column on the “DATA PROCESSED” sheet called “Sites Visited” (col BT). In this column I have concatenated the “Site Name” columns from entries 1-10 but I would like to only return the first instance if the site name in entries 1-10 is duplicated.

In cell BU4 I tried this formula:
=TEXTJOIN(“, “,1,UNIQUE({D4,J4,Q4,X4,AE4,AL4,AS4,AZ4,BG4,BN4}))
but it is still giving me duplicates (Office, Sheraton, Sheraton). I would like it to just return:
“Office, Sheraton”

Thanks in advance!!