Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations KootK on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Very Large Pivot Table /Array - Access

Status
Not open for further replies.

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 ...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor