Here's my conundrum.

I have some data that I've exported from MS Access. It contains multiple categories. So, for example, someone could be into apples, oranges and pears, and also into dogs and cats, and therefore the data looks like this:

**NAME ANIMALS FRUIT**

Joe Bloggs Cats Apples

Joe Bloggs Cats Oranges

Joe Bloggs Cats Pears

Joe Bloggs Dogs Apples

Joe Bloggs Dogs Oranges

Joe Bloggs Dogs Pears

How do I transfer the data so there is only one entry for Joe Bloggs without having to do it manually. We have over 5000 entries and an intern working on it manually at the moment. She's calculated it's going to take her well over 100 hours to do the whole thing.

Any help much appreciated.

Matthew