I need to find multiple words in one column and replace them with one word in the adjacent one.
I have this headings
Category SubCategory
word1
word2
word3
Each category is related to several subcategories, so I need to find multiple subcategories, and when it finds a match replace the blank space under Category with their corresponding category.
Like This
Category SubCategory
Home Theater Movies & TV
Home Theater Home Theater in a Box
Home Theater another subcategory
now I have only the subcategories, I need to fill the categories with the macro or script.
Bookmarks