How to isolate mutually exclusive rows?

[canyon]

I have a dataset with over 690,000 rows of the various parts and components for my companies vehicles and their variants. Right now I am trying to isolate the parts that are unique to a particular variant... is there an easy way to do this in PQ or excel?

 

[canyon]

Image added for clarity.

 

[severynm]

Hi! I'm not typing your data by hand so I made up some sample data instead.

variant	id
van	1
van	2
truck	3
truck	4
motorcycle	5
motorcycle	6
car	7
car	7
van	9
truck	3
motorcycle	5
car	10
car	10

Excel 365 and 2021 can make use of dynamic array functions which make this muuuuch easier.

=UNIQUE(FILTER(Table7[id],Table7[variant]="car"))

yields

7
10

Looks like you are not using those versions though, so Power Query is going to be your better bet in my opinion (it's otherwise doable with the other regular excel functions, but it might be a bit complex).
Load the table into PQ, and then filter for variant = car and then remove duplicated on the id column.

let
    Source = Excel.CurrentWorkbook(){[Name="Table7"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"variant", type text}, {"id", Int64.Type}}),
    #"Filtered Rows variant = car" = Table.SelectRows(#"Changed Type", each ([variant] = "car")),
    #"Removed Duplicates from id" = Table.Distinct(#"Filtered Rows variant = car", {"id"})
in
    #"Removed Duplicates from id"

yields

variant	id
car	7
car	10