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
Solved! Go to 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!
Thanks for sharing these images. it is really helpful.