0
votes

let's assume the data should like:

Words remove this word in first column
Michigan address 21356 21356
Hawaii 31256 address 31256
1235 broadway niceblock 1235

I have data like that. I want to remove some words in the first column based on the second column value. How can I do that?

I tried some loops operation but didn't make it. Thanks for any help