Split csv cells without separator?

Question

PHP

Unfortunately, "products" and "sections" are merged. You need to separate them into separate cells and save them in a new file.
There is a separate list with goods and a list with sections in txt. The trouble is that there is no separator between products and sections, only a space, but both products and sections can be of several words.
I am attaching a screenshot.

Answer 1

As I understand it, there should be much fewer sections than goods. If yes, then the easiest way is to write a regular expression, where the space before the section is replaced by a separator.