You can use the info from this thread to accomplish this.
Just update the destination field to what you prefer (%mixartist% perhaps?)
Note that it does appear from your examples that several have multiple artists split into separate fields, that is indicated by the double backslash character. You can combine these before you run the above action first, using the Action(Quick) function Merge Duplicate Fields.