Forum Discussion
Power Query Time Detail Report Rows
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.That's because it was my initial presentation to you inquiring if your desired result was something similar to the image I presented (so you can't expect in depth analysis to the data set).
So what do you suggest to do with the surprise bugs that come out of the wood work such as these:
employees with not four but six punches (probably the reason why it stuck out like a sore thumb in the initial image i presented)