hello,
I'm having a hard time figuring out the
following problem:
I have customer information (text) in
column A, one per line. And I have product
information (text) in column B, one per
line; a typical excerpt would look like
Joe hammer
Joe nails
Joe paint
Joe bucket
Eve hammer
Eve needles
Jim nails
Jim paint
Jim needles
What I'm trying to achieve is a row - or,
when the alphabet runs out, multiple rows,
based on the data as outlined above:
Joe hammer nails paint bucket
Eve hammer needles
Jim nails paint needles
where every product gets its own cloumn within
the row.
I assume I'll be needing a macro for this,
and that macro would have to check how often
a single customer entry exists in the A
cloumn (indicating how many products
altogether are associated with that customer),
and copy the current value of column B into
the next free column beside the customer
designation.
Also, I believe that for large 'orders', the
Excel approach of A,B,..,Z is not enough; my
current project has some 65k customer/order
pairs, and Joe alone has ordered more than
260 products.. hence I _assume_ that more
than one 'Joe' column will be necessary.
[heh - English is not my native language, and
I doubt I'm making myself understood]
Is this at all possible?
I'm having a hard time figuring out the
following problem:
I have customer information (text) in
column A, one per line. And I have product
information (text) in column B, one per
line; a typical excerpt would look like
Joe hammer
Joe nails
Joe paint
Joe bucket
Eve hammer
Eve needles
Jim nails
Jim paint
Jim needles
What I'm trying to achieve is a row - or,
when the alphabet runs out, multiple rows,
based on the data as outlined above:
Joe hammer nails paint bucket
Eve hammer needles
Jim nails paint needles
where every product gets its own cloumn within
the row.
I assume I'll be needing a macro for this,
and that macro would have to check how often
a single customer entry exists in the A
cloumn (indicating how many products
altogether are associated with that customer),
and copy the current value of column B into
the next free column beside the customer
designation.
Also, I believe that for large 'orders', the
Excel approach of A,B,..,Z is not enough; my
current project has some 65k customer/order
pairs, and Joe alone has ordered more than
260 products.. hence I _assume_ that more
than one 'Joe' column will be necessary.
[heh - English is not my native language, and
I doubt I'm making myself understood]
Is this at all possible?