OK here's the issue as best I can explain it:

In column A there are multiples names all associated with one name in column
B. For example:

Col. A Col.B
Jimmy Doe John Doe
Jackie Doe John Doe
Joey Doe John Doe
Jane Doe James Doe
June Doe James Doe

What I need is all of the names in column A to be listed in rows rather than
columns so for example:

Col. A Col. B Col. C
Col. D
Jimmy Doe John Doe Jackie Doe John Doe

I know that what I want to do is systematically possible, I just hope I've
explained it well enough. I'm comfortable working with VBA code, just not
quite sure how to set it up.