Separate / Combine words in a String and put them on a new row.

[calvincarr29]

I need this:

To look like this:

 

 

[TUSHAR050392]

Hey @calvincarr29 

I see the data that you want to separate has % as the common delimiter. You can use text to column and % as delimiter and keep number of column - 2. This will be generate the two new columns with 50 values and you can name them as Value3 and Value4

Then you need to do some manipulation of existing data using a formula tool. For Value2 column you will write IF ISNULL(Value4) THEN Value2 ELSE Null() ENDIF and same for Value3 column

Hope this helps.