have a list of thousands of rows in excel. one column is called categories such as accountants, airports, lawyers, etc. I count at least 2000 different categories. I need to reduce this to to somewhere around 300-500. Now this will not be so simple. You must take the excel and reduce the categories to main level. For example: there is a category called accountants and then accounting services. The category needs to be changed for all these listing to accounting services.
It will take some time to do this ..
I have attached a SAMPLE file of what you will be working with. This is a sample.. the actual file is much bigger but the same idea just with more listings. WIll not be more work as you are working with the categories and not number of rows. Does not matter if 1000 or 1 million rows...
Work will be done in efficient way. Please consider.