Tables :: Concatenate Field Names But For Each Record Order Can Be Different

I have
Field1
Field2
Field3

I need to concatenate these three fields into one but for each record the order can be different. What I want to do is have another field in the table to store the concatenation order as the field names not the field values.

I also need to display the concatenated field as the actual field values and not field names in a form or a report

So if field4 was the concatenated field store it would store the information like this

[Field1] & " " & [Field3] & " " & [Field2]

In a form or a report

Field4 should show as Values of those fields

Monkey Dog Cat