I have a worksheet with a drop down list containing about 10 items. Obviously as the list is used these items are selected and the list could typically look like this:
dogs
cats
pigs
cats
cats
dogs
elephants.
For each of these animals there is also a name, which could be different.
On a separate worksheet I want the data to be automatically group according to type, in other words, I want all the dogs’ names to be grouped together and then all the pigs names etc.
Is there anyway to do this except for doing it manually?