I am looking for a way to modify my excel file to import my vendors for my product templates via name. The problem is I have to seperate multiple names in excel so Odoo can recognize it as one name. So instead of having one Vendor name in one cell I want to have one cell with Vendor names, but recognized by odoo as individual. Is there any expression I can use?

I am aware of using keys and ids is way better but I have plenty of products and I dont know their keys

Instead of this :

I need it to be like this:

I want to prevent something like this