Filtering With Multiple Sub-items (Many Rows) Per Single Item (One Row)

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.)

Originally Posted by CRIMEDOG

The easiest thing I can think of - Leave the episode title line blank Column F...
Start the Music info one line down
Then when you filter for writers - Check the writer's name and Blanks

Otherwise you could build some summary page...

Ahh that's clever, I didn't realize that could work that way. That still does include a large amount of unneeded data in the filter on the actual sheet I'm working with (which has dozens of other episodes being added); but it's definitely a solution I can live with. I'm not sure how a summary page would work, but I might do some research on that as well. Many thanks!

Originally Posted by LeoTaxi

i see writers in column I
i dont see why you could not filter on column I


Kind regards
Leo

Sorry, I should have been clearer. With my setup, filtering on column I doesn't tell me which episode each cue is from unless it's on the first row of the episode.