How to summarize duplicate columns

[Powerbing1]

Hi 

I have a list of entries where the product code is the same but the product name is different example

Product code Product Name

1234               Book Hello

1234               Book Hello Hardcover

I want to have a table that summarizes this table. The Product code is simple as it could be summarized through distinct value, however to then vlookup against the product code against the product name it will give me two entries. I want to be able to choose any of the product names to become a single product entry.

How do i do this?

[amitchandak · Accepted solution]

@Powerbing1 ,

a new table

Prd = summarize(Table, Table[Product], "Name", max(Table[Product Name]))