Help

Check this out, you have the name of the vendor in your Mat Description,  you create a duplicate of your material and split it into the first part until vendor and last part with vendor, then you split the vendor column into one part of the vendor itself, then you compare them, if it is the same, then you take the base Mat description, without vendor name, if they are not the same then you take material as it was. 

Might be a bit confusing, but check the power query and if you still have questions, let me know.