How to replace string with null value and put the string into new neighbor column

Question

Dears,

would you be able to help me with the following intention?

I need to replace the string in column "value" with null and put this string into new neighbor column "other tools". Also in the next step I would need to split each word from the new column to the separate row. All steps are demonstrated below.

Could you just give me a hint which way to go?

Thank you a lot for your help :) .

messi007 · Accepted Answer

@KaMa,

Please see below:

1- Regex replace to replace any number with null

2- Text to column to split column on to row based on ","

Attached the workflow,

Regards,

binay2448 · Accepted Answer

Hope this will help, I have two output you can choose according to your need.