I have a data request where I have two columns, one is an Parent_ID column with a single value and then there is a Child_ID, where multiple ID's can be entered into the column. I need to be able to separate the Child_ID ID's and keep them attached to their Parent ID.
What I have:
| Parent_ID | Child_ID |
|---|
| 276 | 400,265,500 |
| 3003 | 120,3003 |
What I need:
| Parent_ID | Child_ID |
|---|
| 276 | 400 |
| 276 | 265 |
| 276 | 500 |
| 3003 | 120 |
| 3003 | 3003 |
Any suggestions?