The link below containas a sample data .xslx (Two tabs, Raw Data and Desired State)
Simply put, I have one column of Visitor IDs, and the other a timestamp. If for example I look over the course of a year, I may see repeated Visitor IDs (i.e. the individual has visited the site multiple times over the last year) however the adjacent column is timestamped.
I would like to dedupe the Visitor ID column (Column A) so the data is distilled down to a single instance, showing the latest (newest) timestamp.