Has anyone ever heard of a function which combines the
content of two rows or cells -or organizes (sorts) those
rows or cells dependent on the presence of a specific
character string?

ie:
NAME DESC P MGR P NAME
Terry RD Chris Blue T CDV, Blue T STD
Jana CS Jim PRS CONV
Jo RD Chris, Jim Blue T STD, PRS CONV
Don RC Pam LTS GOLD D
Jack RD Chris Blue T STD
Anne CS Jim PRS CONV
David RD Chris LST GOLD D
Ed RC Chris Blue T CDV, Blue T STD
Tim RC Chris, Pam Blue T CDV, LTS GOLD D


RESULT of BLEND()

P NAME P MGR TEAM
Blue T CDV Chris Terry RD, Tim RC, Ed RC
Blue T STD Chris Jo RD, Jack RD, Ed RC, Terry RD
LTS GOLD D Pam David RD, Don RC, Tim RC,
PRS CONV Jim Jana CS, Anne CS, Jo RD