Hi, I have a dataset that looks like below. Column-1          Rank     row1               A     row2               B     row3               C     row1               B     row2               A    I am trying to achieve a dataset where only unique values of Column-1 are listed with considering only the highest rank record where A>B>C in ranking. Like this: Column-1          Rank     row1               A     row2               A     row3               C Any help is highly appreciated. ... View more