Filter Issue

Hi all (moved to proper topic,

My problem is has to do with a filtering of a table like the following. When I filter column "3" for AAA the result is "Child-AAA." Is there a way to filter in a way where the "Parent" of the child also shows up??? I will have many children from different parents. I'm looking for a way to filter for child but have the parent also be visible.

Thank you in advance!

1	2	3
Parent
	Child	AAA

Could this only have a VBA solution?