I am new to this software and am looking for some help in solving a seemingly simple problem that I am however stuck on.
As in the example reposted below I have a list of brands (column 1) and a list of products (column 2) in which the brand is also inside. What I would like to do is to be able to split these two pieces of information, identifying which brand is inside column 2 and then create two new ones one with just the brand and one with just the product.
Hi @HansS Thank you very much, you have brought me very close to the goal!
One thing I didn’t specify is the assumption that the band column (Column 1) is incomplete and you don’t know any names/rows.
In this case in the ouput result in the “product column” there should be all the product name and brand, instead in the result of the “brand column” there should be a constant that makes this situation clear (like a string “not know”).