I have a power query which it is basically a time clock.
I have a date and user first name and last and time they clocked in and then clocked out. I need to combine the the two columns based on the date and the user first name and last name. See example below.
The final result would be
3/4/2019 megan cunningham 8:58 am 2:17 am 3:17 am 5:58 am
3/5/2019 megan cunningham 9:00 am 2:32 am 3:37 am 6:14 am
This would be done for each date .
it is basically merging any other column that matches the same date and same username and adding the other times. I have tried to group by and then do a list but i could only bring in one value.
I have created a spreadsheet with the results tab on how i want the data to look.
7 freelancer đang chào giá trung bình $23 cho công việc này
Hi there, I have seen your project details, I can do this data filling job in the excel file. I understand your requirements. Please message me, I am ready to start now. Regards, Mou