It will be easier if I could hard code a delimiter.
While your need is for a comma delimiter, I've seen other coders who need commas in the data. Hmm.....

Upgrading to a ConcatIfs is one of those projects that I've been putting off.
I hope there isn't a rush, since I probably wont have time until the weekend.
If that time scale works for you, great.
If you need it sooner, give it a shot yourself and I can guide you through any problems. If you do it your self, dump the NoDuplicates argument and the If Instr.... line.