If you provide sample data, it might help us to create some sample views for your reference.
Attached is a simplified spreadsheet:
I have this author's (CF Andrews) books all listed with variables such as title, length, and subject. The goal is to eventually make such a document with all of his articles as well (of which there are over 200).
I have also included a test workbook that I made (with added reference lines to mark important events in the Indian independence movement, with which CF Andrews was intimately associated).
Thank you for any advice you might have.