Convert list of names to list of numbers

I have a list of names that are repeated for example: Cat; cat; dog; horse; dog; etc. in a column and I have a legend , a table, where for example there is dog, 1; cat,2; horse,3; how can I get a col...