I'm trying to clean and organize a data set that has user IDs, date and time to the second, and heartrate. What I'm trying to do is change this data set from measuring heartrate by second, to heartrate by minute by removing duplicate values after the first unique value. However, columns A (user IDs) and B (time) are both reliant on each other and both contain duplicates. I need to change it so that there are one unique combination of each for columns A and B together.
enter image description here This is a snapshot of my data. Example of what I need would be one value for 5/9/2016 19:49 for user ID 123456789, but also one value for 5/9/2016 19:49 for user ID 987654321, and so on for each value of time.
