Applying a code to to rows with a certain key word.

[DanMBrx]

Hi,

I am looking to add a code to any rows within a data inventory which contain certain key words. The code will be the same for all matching rows and the code will be added to a new column. I then want to be able to merge the the matched rows and the unmatched rows back into the original spreadsheets, the only thing that should be different about the new spreadsheet is the code column added and all rows which contain the key words have the code in said column. 

Sorry that is best I can explain what I need, hope someone can help.

Thanks in advance,

Dan

[binuacs]

@DanMBrx Based on my understanding I updated the workflow, let me know if you are looking for something else.