Offer Approver Names

Summary

All approvers in one column, need 1 name per column for row.

Content

Offer approver names are all within one column unlike the req approvers. 

How can I break apart each approver into it's own column similar to req approvers? 

I tried a couple of different case when statements and tried incorporating sequences but I'm only returning error messages. 

Thanks, 

Amanda