Filtering entries in Excel with multiple connected data on adjacent column

[eggcellnoobs]

I'm sorry if my title is confusing, I'm fairly new to excel.

Below is a sample image, basically what I want to do is be able to filter the Topics. But when I filter to see -- Climate Change for example -- it does not show that it is a topic for the "Duis vulputate tempus" book. Would like to ask how I can connect the Title to all the Topics related to it. Thank you all in advance.

XeC2X.jpg

[JohnTopley]

You need the title/author in every line if you want to filter.

[eggcellnoobs]

You need the title/author in every line if you want to filter.

Thanks for the reply. Is there a way I can assign more than 1 Topic to a Title? But still be able to filter Topics one by one. Or is this just not possible?

[JohnTopley]

As per my previous post, you need the title on every line for each topic. The alternative is to have TOPIC in multiple columns rather rows so if TITLE is in column B, then topics will be in columns C, D , etc.

[eggcellnoobs]

As per my previous post, you need the title on every line for each topic. The alternative is to have TOPIC in multiple columns rather rows so if TITLE is in column B, then topics will be in columns C, D , etc.

Got it. I might just go with adding multiple columns for the topics. Thanks!

[torachan]

Apply the simple filtering logic that would be used in a 'database' table.
Keep data entry as simple as possible and make the code do the donkey work.