Help with filter function

[UniqueUsername1]

Is there a way to combine these two formulas into one?

=FILTER(Table1,Table 1[Team 1]="Jake","")
=FILTER(Table1,Table 1[Team 2]="Jake","")

 

[p45cal]

=FILTER(Table1,(Table1[Team1]="Jake")+(Table1[Team2]="Jake"),"")
or to prevent you needing to enter Jake twice:
=LET(nme,"Jake",FILTER(Table1,(Table1[Team1]=nme)+(Table1[Team2]=nme),""))
or:
=FILTER(Table1,MMULT(--(Table1[[Team1]:[Team2]]="Jake"),{1;1}))
or if the Team1/Team2 columns are not next to each other in the table:
=FILTER(Table1,MMULT(--(CHOOSE({1,2},Table1[Team1],Table1[Team2])="Jake"),{1;1}))

 

[UniqueUsername1]

=FILTER(Table1,(Table1[Team1]="Jake")+(Table1[Team2]="Jake"),"")
or to prevent you needing to enter Jake twice:
=LET(nme,"Jake",FILTER(Table1,(Table1[Team1]=nme)+(Table1[Team2]=nme),""))
or:
=FILTER(Table1,MMULT(--(Table1[[Team1]:[Team2]]="Jake"),{1;1}))
or if the Team1/Team2 columns are not next to each other in the table:
=FILTER(Table1,MMULT(--(CHOOSE({1,2},Table1[Team1],Table1[Team2])="Jake"),{1;1}))

Thank you!

 

[Peter Bartholomew]

And now for something different

WorksheetFormula
= FILTER(Table1, BYROW(Table1, Matchesλ("Jake")))

Matchesλ
= LAMBDA(name,
     LAMBDA(record,
        OR(record = name)
     )
  )