Hi all,
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
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