Get it on one line

[bfield66]

I am trying to get all of the names on one line. I've attached an example. Column A is the part number, Row 1 is the column header describing the functions, and the names of those utilizing the part for which function.

Thanks

[#2 · Accepted solution]

@bfield66 

See the attached version.