[Sparkie]

Thank you! I printed it out and have tried it once - it did not work - will
try again. However, in the meantime, if I am extracting the data from CRM
via a mail merge add-on, will this formula still work?


"Sparkie" wrote:

I'm trying to merge a list of names by category. Is there a way to do this
directly into a one column list? If not, can I merge them into two columns
and avoid repeating the multiple categories?
i.e.
Instead of:
Red Chris
Red Tom
Should be:
Red Chris
Tom
Or better still:
Red
Chris
Tom
Thanks