I have imported a lot of transaction data from Excel. Many transactions
belong to the same account. However, it appears in Access as different
record. How can get the data of same account merged together. Do I need to
set up the table in a certain way? Can somebody help? Deeply appreciated.

Thank you,
Linda