Separating string content in a single column into multiple columns, dynamically

[RMotta2408]

Hello everyone.

How do I extract a string content from a column into multiple columns?

I have this:

And I want to turn it into this:

Mind you, the original column "TEAMS" may have a different number of values. So the Job has to be dynamic to create as many columns as the values in the original "TEAMS" column.
The "-" character is the values separator.

I just can't seem to get over this hurdle.
Can anyone please help me?

Thank you so much,

Rui

[Shicong_Hong]

see the below image, this expression create the columns based on the number of values in "Teams".

"team"+Numeric.sequence(row3.id,1,1)