Can you share a bit more about what kind of values can appear in column you would like to split? And in case there is no match what value should be in new column? Missing value or fixed value or? From experience dummy data input with desired output is usually a best way to get help/ideas/solutions