Remove duplicates in and keep the row with highest price

[Anonymous]

Hi,

I want to remove duplicates based on the first column, but keep the row with the highest price based on the last column. So in the image item 0000.9166 should keep the row with price 11.85

Thanks

[NishPatel · Accepted solution]

In Power Query Editor, do a group on item and create a new column with Max on Price. 

Below is the data

after applying below grouping

This is the required result