Keep Rows based off value in another column

[bchen1]

Hi everyone,

I have a list of products and various "versions" associated with each. Some products have multiple versions and some only have 1 version. I want to have 1 row per product with the following priorities/rules:

Priority: Final > Second > First. Keep only 1 version of a product.

Current

Product Name	Version
Product ABC	First
Product ABC	Final
Product AA	First
Product AA	Second
Product AB	Final
Product AC	Second

Desired Output

Product Name	Version
Product ABC	Final
Product AA	Second
Product AB	Final
Product AC	Second

Any ideas on the best way to go about doing this? Thank you!!

[OllieClarke · Accepted solution]

Hey @bchen1 

Here's how I'd do this:

I've used a text input to set the desired order, but you could have this as an external lookup for ease of updating....

Ollie

[binuacs]

@bchen1 One option to use the summarise tool

[Emmanuel_G]

@bchen1 

One way of doing that in attachement.

[bchen1]

Thanks everyone. All options work - appreciate the help!!