in reply to Get the string value from one column and append to another column

Try the following approach

Probably you need some fine-tuning with the regular expressions ;-)

HTH, Rata