Generate a one to many for the same table

I have unstructured data like so in one column - and I would like to split it out:   TABLE 1 RawData 519 ABC XYZ 520 AAA BBB CCC DDD   So, I need to write some DA...