Transposing problem - please help if you can

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

 

[Bob Phillips]

See response in .programming.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Bill Ridgeway]

A Pivot table should bring the information together in the format your
require. If you want to make the new format permanent you could then copy
the pivot table data into a spread-sheet.

Regards.

Bill Ridgeway
Computer Solutions