September 9, 2020
I have some initial data in an ASIS tab (in reality I have other columns that I have deleted for better readability). Some of these data are duplicates if I only take into account the columns: Date - H - M - TEL_CALLER - TEL_CALLED - DURATION - ANSWER.
Is it possible with Power Query to keep a single unique value corresponding to the earliest hour of the day?
In the ASIS sheet, I put the cell in red in the J column for those that need to be deleted. In the TOBE sheet, I put the result I am trying to obtain.
Thank you very much for the suggestions for a solution.
November 8, 2013