Comparing two rows with the same time stamp and picking the higher value from a different column
Hi, I have a dataset where by I have a single column with minute by minute data (time stamped) and in many cases the same minute is duplicated. For those instances, there is another column with different values. How do I find duplicated timestamp rows and pick the max. value between them e.g.Initial TableTime Flow12:00 34512:01 123 12:01 45612:02 22312:02 11212:03 ...