Hello,
It is quite difficult to answer without a better understanding of these tables' structure, but here is what I have done to give you a hint.
Table Formation 1

Status is a single select field
Table Formation 2

Status is a single select field
Formation is a text field taking the information from table "Formation 1"
Automation

Trigger set on Status = "Refused" on table "Formation 1"
Action create record in table "Formation 2":

Status is set to "Pack solo" (make sure that this option has been set on the field Status in table "Formation 2")
Field formation is fed from table "Formation 1":


Regards,
Pascal