All of the collections on my Kobo are 'Author - Series' format ('Armstrong, Kelley - Otherworld' or 'Bishop, Anne - Black Jewels'), so that is the output format I am looking for.
My understanding of authors in Calibre is that the author sort field is attached to each book (I can go to the metadata of each book and see 'author display' and author sort') and it all comes from the same place... but from what you are saying is that even though I have an 'Author' column (default from Calibre), I need to add an 'Author Sort' column as well? Or do you mean I need 1 column that combines the 2 fields ('Author_sort - Series')?
Current Columns:
