How to split item into two and create new row with 2nd item?

Help
1

Hi All,

Hopefully you guys can help me…How can I convert my Current DT to my Ideal DT.

In SQL I would split “Persons”, then transpose. Was wondering if there is anything similar within UiPath.

Current Data Table:

Type Persons
1 PersonA,PersonB
2 PersonY,PersonZ
3 PersonX,PersonC

Ideal Data Table

Type Person
1 PersonA
1 PersonB
2 PersonY
2 PersonZ
3 PersonX
3 PersonC

Thanks in advance everyone.

2

Loop the DT in a for each, split each row and add the 2 elements as new rows in a new DT.