Comment Section to Categorical Data (Columns)

[Justijb]

Good Morning All,

As always, I must start out my posts with a big thank you to everyone who contributes to this forum. So I have a bunch of data in various columns with only one column I need to convert to categorical data.

Column H is what I will need the script to focus on. I have a seperate table with 10 key words or codes that the comment section will need to match to seperate into additional columns.

Column H = I have dogs and cats and mice in the house (text form, sentences, random words, codes, abbreviations)
Table is Dogs = Darg1, Cats = Cart2, Mice = Mouse5
Column I J K L = Darg1. Cart2. Mouse5

I am trying to convert a comment section into categorical data from a table I devloped.

Please let me know if further explanation is needed. Thanks.

V/r

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1099839-data-find-sort-post5288204.html#post5288204

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).