Data Splitting/Column Divider Automatization

Greetings!

I am looking for a solution regarding a rather specific objective I find myself dealing with. I am to find a way that would allow data to be split into different columns automatically. So far, the only thing I found was the Text to Columns Wizard, but that is manual, and I would need something that could do that automatically. And to be make that a little more complicated, there should be certain words that are recongized and added to a different column than the rest of the data.

Is making such an automatization possible? If yes, how would one go about that? And if not, could you recommend another method to separate data automatically by any means?

Your help will be much appriciated!