G
garyusenet
Hello, I have been puzzling over this for some time now and am sure a
seasoned excel person will have a solution.
-----------------------------------------------------------------
First let me explain the spreadsheet.
-----------------------------------------------------------------
It is a list of customers, and purchases that each customer has made.
every purchase has a unique row.
for example: -
CUSTOMER ITEM
customer a someitem
customer a someitem2
customer a someitem3
customer b someitem4
-------------------------------------------
What I want to end up with
-------------------------------------------
customer a someitem someitem2 someitem3
customer b someitem4
etc ...
the problem is that the number of purchases varies between customers,
some have fifteen or so whilst some have three so i'm having trouble
figuring out a way of automating it.
I've simplified the example but in reality there are about 10 columns
which belong to each purchase, and these are what I need to append to
the end of the customer row.
I hope someone can help because there are over 4 thousand rows - so to
do this manually is going to take me a week of sundays
Thanks,
Gary.
seasoned excel person will have a solution.
-----------------------------------------------------------------
First let me explain the spreadsheet.
-----------------------------------------------------------------
It is a list of customers, and purchases that each customer has made.
every purchase has a unique row.
for example: -
CUSTOMER ITEM
customer a someitem
customer a someitem2
customer a someitem3
customer b someitem4
-------------------------------------------
What I want to end up with
-------------------------------------------
customer a someitem someitem2 someitem3
customer b someitem4
etc ...
the problem is that the number of purchases varies between customers,
some have fifteen or so whilst some have three so i'm having trouble
figuring out a way of automating it.
I've simplified the example but in reality there are about 10 columns
which belong to each purchase, and these are what I need to append to
the end of the customer row.
I hope someone can help because there are over 4 thousand rows - so to
do this manually is going to take me a week of sundays
Thanks,
Gary.