update query for import data format

[Guest_imported]

Hi there,

I need some programming help with changing raw data in vertical format into more conventional horizontal or record format that Access will accept for my existing queries and forms. To explain my point the data I have is in the format

Fred apple
Fred orange
Fred pear
Sally orange
Sally apple
Tony orange
Tony banana

I need to change it so that I have one record with multiple columns (random for each record) for each person. Eg.

Fred apple orange pear
Sally orange apple
Tony orange banana

I am under the imression that the best way to do it would probably be an update query, but I've no idea how to get it operating. Any help would be greatly appreciated !!

Thanks

 

[tomschafer]

I'd use a cross-tab query.