Remove group of rows based on column data

Hello, Mikee5 Group by owner, check if [Car] column contains "Toyota" and then select TRUE only. Just an idea.

let
    Source = your_table,
    group = Table.Group(Source, "Owner", {{"rows", each _}, {"Toyota_owner", each List.Contains(_[Car], "Toyota")}}),
    filter = Table.SelectRows(group, each ([Toyota_owner] = true)),
    result = Table.Combine(filter[rows])
in
    result

another option is to filter table to get a list of Toyota owners only and then filter table again by Owners column

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    names = List.Buffer(List.Distinct(Table.SelectRows(Source, each [Car] = "Toyota")[Owner])),
    result = Table.SelectRows(Source, each List.Contains(names, [Owner]))
in
    result