Sorry for the complicated title; I'm not quite sure how to describe my problem. See attached file for the structure.
I've slowly built up a template that is used to track music writing credits per episode of a show. I am at the point where I need to start filtering individual writers to check their history, but the setup makes this difficult. I'm aware of one solution, which is to copy down the episode number and title every time we add a new row/credit for an episode. This introduces its own problems, though: I have a couple of conditional formatting rules that don't play nice with repeating episode info. I am also trying to make the template as easy to use as possible, as it is shared among several people. So it would be preferable to not have to copy info every time a new row/entry is inserted, if possible.
So the main question is, is there a way I can filter out individual writers with my current structure?
A secondary question might be whether there is a better structure I should be following that still maintains clarity and visual feedback, which I've tried to build into this template. (There is person by person conditional formatting as well that didn't properly translate to Excel.)
(Side note: the actual spreadsheet is a Google Sheets document, but I've exported this simplified example to Excel and would be grateful for any solution, even one that only works in Excel.)