Hi there @glimachave,
maybe I’m missing something but this doesn’t seem as a simple problem. I mean it does not contain complex logic but sure isn’t standard data manipulation. So going with scripting (Python, Column Expressions) seems reasonable in this case.
Br,
Ivan