Forum Discussion
Power Query Time Detail Report Rows
Hello, I've been trying to setup a query to on a time detail report where each set of punches is on a different row. Originally we were accomplishing this with pivot tables, but recently noticed ...
Not quite. The goal is to get the four punch's for that day onto one row.
Thank you for helping to solve this.
Not quiet?? ok how many lines do you see for EMP01 on 10/1/2021 and how many punches do you see in the image and how does that not satisfy the specification of all punches for the day in one line? Well I hope you find your solution.
cheers
- EMP01 looks great, but EMP04's the punches fall on two lines. Is there a way to move second set of punches up to the line 13 in column X and Y?
Thank you again for the help.
