Hello,
I have been searching a quite universally used feature like split text to columns, which is something we are quite used to do.
Should be as easy as: SPLIT function - Docs Editors Help
Of course it might need indicating destination fields, but ...