Recent content by jespen21

Hello Pat, thanks for your response. I've got an excel spreadsheet which lists the names, ID numbers, e-mail addresses, room numbers, building name, charge description, amount of charge, and date of charge. For every charge incurred by an individual, all of that information is repeated. For...

I've got a table which lists accounts with an associated charge. If the account has multiple charges, then the account appears multiple times, for each charge. I'd like to consolidate the duplicates without losing each charge that is associated with the account.