Here is how you do it.
1. Use record id tool to set unique key for rows.
2. Using text to column, delimiter as |, and split to rows.
3. Using multi-row formula tool, groupby RecordID, generating group ID. Group id is the position which will be used for mapping.
4. Joining Field 2 & Field 5 on record ID & group ID. This way it matches to row & position.
Hope this helps 🙂