I have done the reverse of this and it was a royal pain. Converted a matrix
into a format for uploading to a database earlier this year. It takes a
series of multi-leveled IF statements, and you need to be comfortable with
that. Let me know if you want more detail and I can send you my formulas.
-Esther

"tjb" wrote:

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.