| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining and merging lines
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!!!!!!!!!!! -- Dawn |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining and merging lines
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: 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!!!!!!!!!!! -- Dawn |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining/Merging Rows | Excel Discussion (Misc queries) | |||
| Combining Excel files into 1 (no merging) | New Users to Excel | |||
| Combining / Merging several rows - but want to keep formatting | Excel Discussion (Misc queries) | |||
| combining 3D with lines | Charts and Charting in Excel | |||
| merging lines | Excel Worksheet Functions | |||
Hybrid Mode
