Help on Finding Matches In One Column Only

[lennox25]

My table is currently set up as below. 

I need to match only the codes  (if they match - there maybe a Code for Product A but not for B and Vice Versa) in which case it would leave a blank on the row for the Product which isnt in this example but it will be the case)

I would like the final result like this(ignore the colouring)

[amitchandak]

@lennox25 , Pivot Product column in Power Query, and then you can have column

if  [A] <> null && [B] <> null then "True" else false

Pivot Data(Power Query) :https://www.youtube.com/watch?v=oKByyI09Bno&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=12

or create measures like

A=  calculate(sum(Table[No Sold]), Filter(Table, Table[Product] = "A") )

B=  calculate(sum(Table[No Sold]), Filter(Table, Table[Product] = "B") )

Result = if(isblank([A]) || isblank([B]) , False(), true() )

Use them in visual with other group bys

[lennox25]

HI @amitchandak  I know how to Pivot and have Pivoted but the column is not working its syntax error?