How to eliminate rows with redundant values and keep other values?

[gordy]

I have a spreadsheet with 64000 lines/28 columns describing potential
customers within several counties (coded). There are multiple customer names
because they do business in multiple counties. I could just break-out
everything by county, but then I'd be contacting the same customers several
times.
Is there a way to reduce the dataset to unique customer names with only one
county code while maintaining the association of these people with the values
in all the other columns?

 

[Michel Walsh]

SELECT customer, LAST(county), LAST(phoneNumber), LAST( whatever)
FROM tableName
GROUP BY customer



Vanderghast, Access MVP