You can do this in two steps using REGEXP in Edit metadata in bulk.
0. Make a backup copy of your calibre library!!!
1. Copy Author from title to authors field.
2. Remove (Author) from title field.
You can brush up on how to write REGEXP here:
http://manual.calibre-ebook.com/regexp.html