Hi @kechi Murphee? ,
The column name can be split into 2 depending on how you brush over the text.
For e.g.
When you brush the first set of characters before a space, it will provide you suggestions to split, extract etc. You can choose extract to fetch the First name. If you brush over the space, the suggestions will be different
If you brush over the end of the character set, the suggestions will be different
Depending upon the requirement, you can prefer to split the columns or extract the values and delete the old columns. You might need to use a few Replace steps to clean up the data.
Hope this helps. If you have any questions, please feel free to provide us with sample data and we can provide a more exact solution.
Best,
Apeksha.