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