Split Rows based on row values from 2 columns and match

David-teryx

Hi All, 

I have to generate a row for each ProductName with its own ProductValue but couldn´t figure out how it can be done.

My input looks like this

CompanyName	ProductName	ProductValue
Company1	ABC,CDE,FGH	RG?,1XE,HS8
Company2	X7-8	RT,UV
Company3	R2,A4-5,B1-3	15D5?T

Now, the desired output should look like this

CompanyName	ProductName	ProductValue
Company1	ABC	R
Company1	CDE	G
Company1	FGH	?
Company1	ABC	1
Company1	CDE	X
Company1	FGH	E
Company1	ABC	H
Company1	CDE	S
Company1	FGH	8
Company2	X7	R
Company2	X8	T
Company2	X7	U
Company2	X8	V
Company3	R2	1
Company3	A4	5
Company3	A5	D
Company3	B1	5
Company3	B2	?
Company3	B3	T

Please help! 🙂

atcodedog05

Hi @David-teryx 

Here is my approach to the task.

Input: table given by you

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Split col.yxmd