Hi,
I have the datasets that is something like below:
| Value | ID |
| 1 | A,B,C |
| 2 | AA,BB,CC |
| 3 | A1,A2,A3 |
| 4 | A2,B2,C2,C4 |
Here is the desired outcome:
| Value | ID |
| 1 | A |
| 1 | B |
| 1 | C |
| 2 | AA |
| 2 | BB |
| 2 | CC |
| 3 | A1 |
| 3 | A2 |
| 3 | A3 |
| 4 | A2 |
| 4 | B2 |
| 4 | C2 |
| 4 | C4 |
I am able to do it in designer using workflow, however the method I use is very static and needs multiple selects. I wondered if there is a way to do it in more automatic way especially that my dataset might contain +25 ID initially inside the same cell.
