Categorizing big amount of data

[Xandaa]

hey, I have a problem with categorizing a large number of data. I have to categorize 48,000 item and the way I do now, it takes way too long. I type the category manually every time. Does someone have a faster way to to do this, maybe with a code for example?Stock_sample_20150609_1220.xlsx