Without a macro..........

DataFilterAdvanced Filter

Copy to another location.

Unique records only.


Gord Dibben MS Excel MVP

On Tue, 15 Sep 2009 12:46:01 -0700, mrsjcd3
wrote:

How do I go from this:
id name email zone 1 zone 2 zone 3
123 john dog
123 john cat
456 mary cat
789 sue dog
789 sue cat
789 sue rabbit

To this:
id name email zone 1 zone 2 zone 3
123 john dog cat
456 mary cat
789 sue dog cat rabbit

Thanks!