Remove duplicates excel for mac 2011

broken image

Ideally all the keywords are within the landing page, but use different subfolders, so I can’t just use a concatenation, I need something else instead.

broken image

What excel formula would I use to match keywords in one column to their respective landing pages in the other column.