Maybe the book has the correct metadata (IF YOU HAVE NOT DONE ANYTHING THAT WOULD HAVE CHANGED IT)
In the Metadata Editor for a book: Select the format: Click the blue i icon (get metadata from the book)(
the brown book gets a declared cover)
Otherwise:
You need a spare column of the correct type
(applies to only on books with the same issue AT ON TIME)
Use the Bulk Metadata: Search and Replace to 'walk' (rotate) the data between fields I use REGEX mode
Source field:
search (.+) <everything in the field (series and series index may need 2 capture groups)
Target field: <spare or empty target field. IT WILL OVERWRITE>
Replace: \1
Repeat until the Title, Author, Series, Series_Index are in the right places