How to filter for rows based on value match?

[overhead_press]

Original: 

E&O	[NULL]	[NULL]
NAME1	1	11
E&O	[NULL]	[NULL]
NAME1	2	22
NAME2	3	33
P&C	[NULL]	[NULL]
NAME1	4	44
E&O	[NULL]	[NULL]
NAME1	5	55
NAME2	6	66

Desired result:

E&O	[NULL]	[NULL]
NAME1	1	11
E&O	[NULL]	[NULL]
NAME1	2	22
NAME2	3	33
E&O	[NULL]	[NULL]
NAME1	5	55
NAME2	6	66

hi everyone, is there a way to filter my table so that every time it sees "E&O" it will filter for that row plus all the values below it. If it sees another heading like "P&C" in the example (headings are distinguished by the null values in the other two columns), it will ignore it? Thanks in advance!

[atcodedog05 · Accepted solution]

Hi @overhead_press 

You can Multi-row formula to group and filter it out. Refer below

Workflow:

Hope this helps : )

[overhead_press]

Thanks for the great solution, what if lets say there are hundreds of other codes that aren't "E&O". Is there a way to adjust what you have to account for that instead of hard coding each code that isn't "E&O"? 

[atcodedog05]

Hi @overhead_press 

We can do something like below.

Workflow:

Hope this helps : )