converting vertical data list to horizontal data list

T

tjb

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.
 
E

Esther

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
 
R

Ragdyer

From your example, if I understand it correctly, it looks like you want to
copy across columns, along a row in this manner:

A1, B1, A2, B2, A3, B3, ... etc.

If that be the case, enter this formula *anywhere* and copy across as
needed:

=INDEX($A:$B,COLUMNS($A:B)/2,MOD(COLUMNS($A:A)-1,2)+1)

If I guessed wrong, post back with the order of the cells that you would
like.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top