data compile

hello all

I have a problem trying to figure out how to compile some data. I have two columns. One of zip codes and one of cities. What i need to do is remove the duplicate zip codes and list one cell for the zip code and one cell for the cities in that zip code and remove the
duplicates for the cities. The cities duplicates need to be removed once it is found
by zip code as different zips will have duplicate city names

eg

Please Login or Register  to view this content.

Any help with this would be appreciated. If the cities could be listed alpabetically that would be an added bonus but no worries.

Thanks
OMK

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save