Does the DeChambeau, Snedeker, Gay part of your concatenated text lives in different rows or different columns?
I imagine you can have a formula to split just that part from the name, then join them using a relation > joined list.
Regarding your question, I think you can only do that via an arrayformula in Sheets.