>You might be best served to leave them as multiple records and use SELECT to bring the records you want together when you need them together.

Or better yet, bite the bullet now, and create a customers table and a transactions table with a one to many relationship between them, and a unique id to link them together ;)