I all, hoping someone can help me with this one...

So I've got a table that contains a list of materials required for a project, essentially similar to this:

table.png

What I want to do is to display all material for lines with (for example) PVC pipe as one of the materials.

The result of this filter would be:

table1.png

So it lists all the materials for drawing numbers that contain "PVC pipe" as one of the materials.

Is there a simple way to do this without adding additional rows or using macros? On top of that - is there a way to also filter this way using a pivot table?

Any help is greatly appreciated!