Convert list of names to list of numbers

%3CLINGO-SUB%20id%3D%22lingo-sub-1558974%22%20slang%3D%22en-US%22%3EConvert%20list%20of%20names%20to%20list%20of%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1558974%22%20slang%3D%22en-US%22%3EI%20have%20a%20list%20of%20names%20that%20are%20repeated%20for%20example%3A%3CBR%20%2F%3ECat%3B%20cat%3B%20dog%3B%20horse%3B%20dog%3B%20etc.%20in%20a%20column%20and%20I%20have%20a%20legend%20%2C%20a%20table%2C%20where%20for%20example%20there%20is%20dog%2C%201%3B%20cat%2C2%3B%20horse%2C3%3B%20how%20can%20I%20get%20a%20column%202%3B2%3B1%3B3%3B1%3F%20Where%20every%20names%20is%20convert%20in%20associated%20number%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1558974%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1559104%22%20slang%3D%22en-US%22%3ERe%3A%20Convert%20list%20of%20names%20to%20list%20of%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1559104%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746184%22%20target%3D%22_blank%22%3E%40michelemascioli%3C%2FA%3E%26nbsp%3Bsee%20the%20attached%20file%20pls%3C%2FP%3E%3CP%3EHope%20this%20solves%20it!!%20otherwise%20please%20tell%20me%20exactly%20what%20your%20mean..%3CBR%20%2F%3Ehave%20a%20nice%20day%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1559152%22%20slang%3D%22en-US%22%3ERe%3A%20Convert%20list%20of%20names%20to%20list%20of%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1559152%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746148%22%20target%3D%22_blank%22%3E%40ramizassaf%3C%2FA%3E%26nbsp%3Byour%20attached%20solves%20it%2C%20thank%20you%20very%20much!!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
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 column 2;2;1;3;1? Where every names is convert in associated number?
2 Replies
Highlighted

@michelemascioli see the attached file pls

Hope this solves it!! otherwise please tell me exactly what your mean..
have a nice day

Highlighted

@Ramiz_Assaf your attached solves it, thank you very much!!