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

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

order.yxmd