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

  • Thread starter Thread starter gordy
  • Start date Start date
G

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?
 
SELECT customer, LAST(county), LAST(phoneNumber), LAST( whatever)
FROM tableName
GROUP BY customer



Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I eliminate duplicate records 1
ComboBox or TreeView and Filtering List 1
List box storing multiple values in field 3
Counting Unique Values That Are Separate by Commas in a Column 2
Multiple values to link to other tables 2
Trying to run excel vba code when cell value changes from empty to entered value. 1
How do I eliminate duplicate entries in a query 2
Index Match Vlookup? 23

Back
Top