As always, you can use an action for this 
Action #1:
Action type: Format value
Field: BAND
Formatstring: %artist%
Best regards,
~ Florian
Edit: You can edit the BAND field also via the extended tag dialog at 
View > Tags... but I guess you are looking for an automated way.