I have a column that has sales reps names. Each rep could be listed mulitiple
times. in the next column I have a text field. (name of a company). If I
wanted to list all the companies associated with a specific sales reps in a
single cell. How would I do that? So the output would look like for Rep #2 =
"General Electric,Boeing,Toyota"

Input:
Column A
Rep 1
Rep 2
Rep5
Rep 2
Rep 4
Rep 2
Rep 1

Column B
Honda
General Electric
HP
Boeing
Dell
Toyota
JPMC