jonnyg75
Computer
- Sep 22, 2003
- 1
I have a table in MS Access with over 500,000 records. I want to pivot of these records based on a certain field, with the 'data' being a list as opposed to SUM or COUNT. However there are too many records for Pivot in Access/Excel and it doesn't allow me to have lists. I'll use a simple example to illustrat
TableA
CustomerID, CustomerType, PetType
1234,MAN,dog
1234,MAN,cat
1999,CHILD,fish
2222,WOMAN,cat
1999,CHILD,snake
1999,CHILD, hamster
4444,MAN,Pigeon
What I want to produce is
CustomerType, CustomerID, PetTypes
MAN, 1234, "dog,cat"
4444, pigeon
CHILD,1999, "fish,snake,hamster"
WOMAN,2222, cat
In my real data the field equivalent to CustomerID would have over 400,000 Unique records.
Anyone know how it can be done easily ...
TableA
CustomerID, CustomerType, PetType
1234,MAN,dog
1234,MAN,cat
1999,CHILD,fish
2222,WOMAN,cat
1999,CHILD,snake
1999,CHILD, hamster
4444,MAN,Pigeon
What I want to produce is
CustomerType, CustomerID, PetTypes
MAN, 1234, "dog,cat"
4444, pigeon
CHILD,1999, "fish,snake,hamster"
WOMAN,2222, cat
In my real data the field equivalent to CustomerID would have over 400,000 Unique records.
Anyone know how it can be done easily ...