How to Transpose the comma delimited data into rows

[mark_paul]

Hello,

Could some one help below 

Input:

ID	Name	Type
123	Test1,Test2	Type1,Type2
124	Test3,Test4	Type3,Type4

Output:

ID	Name	Type
123	Test1	Type1
123	Test2	Type2
124	Test3	Type3
124	Test4	Type4

Thanks,

Mark

[DataNath · Accepted solution]

Hey @mark_paul, I've attached a couple of ways you could go about handling this. One a bit simpler/quicker than the other but the top should handle this more dynamically if you don't always have a 1:1 relationship between the number of [Name] and [Type] you're splitting.

Hope this helps!

[Eden60]

Thanks for sharing these images. it is really helpful.