Text Join - Return Unique Text Only

Hi, I am trying to use text join with Unique function and it does not seem to be working for text. I have successfully used it for values in the same spreadsheet but can't seem to eliminate the dupli...