I have a list, green is the unfiltered data. I tried using SORTN function to remove the duplicates indicated by the incrementing "Counter" column. Found a few solutions online that pointed me towards using something like

=sortn(sort(I2:N,2,0),rows(J2:J),1,2,0)

But I can't get it to remove the extra data, I made a seperate sheet with the desired results. ANy help is appreciated. I thought of using a Query function but I couldnt get it to work either.