Combining and merging lines

D

Dawn

I have a spreadsheet with about 6000 lines of zip codes. It is sorted by
county for each state. What I would like to do, is consolidate the records so
that there is only one row with each zip code for that particular county
instead of one row per county/zip code. Is this possible or am I not being
clear? HELP!!!!!!!!!!!
 
M

Marcelo

hi, if I understand maybe a pivot table could help you a lot.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Dawn" escreveu:
 

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

2 Files with Different Fields 6
Deleting duplicates - kind of 7
address list 7
Drop Down that returns value in same table 5
Match 2 different zip code lists 1
Need VLOOKUP to Work Two Ways 0
How do you suppress blank Address lines during a Word merge? 2
Sort by how many addresses per zip code 4

Top