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.