Database_vScrub.zipI have a database of contacts, is there a way to make a query that will put all contact info on a single row, if there are multiple entries?
For example, my contact are state representatives and senators, the contact info I have breaks it down to what district and city the represent. So my goal is to have a single row based on the contact name.
Name , Office, City1, City1AC, City1Number, City2, City2AC, City2Number, City3, City3AC, City3Number, ect.
With out having to manually create each column header for the city number, is there a formula or query that will create those and populate the fields accordingly? There is one representatives that has a very large number of cities they represent, and looking to make process easier for future use.
Thanks in advance.