Forum Discussion
Solved
Combining several line items into one column in PowerQuery
Hopefully I am phrasing this coherently. Basically, if an employee clocks out for their break and has several time durations during one shift, the output from my job's scheduling system will be split...
1 Fill down the columns of name, date, positions
2 Transform the data type of Shift duration to number
3 group the data by the columns of name, date, positions, and sum the shift duration as Actual.
1 Fill down the columns of name, date, positions
2 Transform the data type of Shift duration to number
3 group the data by the columns of name, date, positions, and sum the shift duration as Actual.
Wowowow, easy!!! Thank you so much!
