You could probably use a combination of scripts to transform the record and inline editing to accomplish that.