Dataview reverse grouping help

What I’m trying to do

i have some character files that look like this:

book: (this is a list) book1, book2, ...

and id like to display a table listing the book titles on the left side and the characters that appear in the book on the right.

book1 character1, character2
book2 character1, character3

like this

is this possible to achieve without adding a “characters” property for books too?

thank you!