I'm losing my mind on something that I feel should be quite easy.
I'm trying to convert data from 1:Many, such as the attached sample image. For example, lets say I have data like this:
<tbody>
</tbody>
https://imgur.com/a/M2JCJ (sample, 1:Many)
I want to convert this to a 1:1 relationship like:
<tbody>
</tbody>
https://imgur.com/a/Qsmfb (desired result)
I've split the data on the commas, but I cannot figure out how to loop through and create the 1:1 relationship. The items field pre-split will have between 1 and 12 items for each "Person"
Thank you very much!
I'm trying to convert data from 1:Many, such as the attached sample image. For example, lets say I have data like this:
Person | Item |
Bob | Bananas, Apples |
Carl | Oranges, Kiwi, Chocolate |
<tbody>
</tbody>
https://imgur.com/a/M2JCJ (sample, 1:Many)
I want to convert this to a 1:1 relationship like:
Person | Item |
Bob | Bananas |
Bob | Apples |
Carl | Oranges |
Carl | Kiwi |
Carl | Chocolate |
<tbody>
</tbody>
https://imgur.com/a/Qsmfb (desired result)
I've split the data on the commas, but I cannot figure out how to loop through and create the 1:1 relationship. The items field pre-split will have between 1 and 12 items for each "Person"
Thank you very much!