Rearranging data syntax on a report

Hi, stumped on this report that I'm doing and would appreciate any help I could get. I'm currently cleaning a report of names where the syntax is SURNAME, (FIRST NAME) (MIDDLE INITIAL) (SUFFIX). I'm trying to change it to (FIRST NAME) (MIDDLE INITIAL) (SURNAME) (SUFFIX). What I did first is to separate the surname from the rest using text to column due to it having a comma. Then use text to column again to separate the rest and use concat to combine it again.

The problem I'm having is that some names have a second and third names so I can't assign one column as the middle initial column. And that some names also have suffixes (Jr. Sr.) while some have none.

If anyone have suggestions I would greatly appreciate it. I don't know if the logic in my process is right. Thanks!