Pivot or CrossTab or Normalize or ?

[Minty]

Re-reading this you appear to simply need your vendor information, the Pname and then All the related CNames separated by a CRLF as an output. This would give you a single record of data per page.

Vendor fields, PName , CName CRLF list in one field.