I have some payroll data (all dummy) that has a start date (PPSD) and an end date (PPED) that ranges from 2022-2023. For the 2022 dates, I want to condense the payroll data down to monthly dates. 2023 will stay as the current biweekly payroll dates. The payroll dates are not consistent across employees so I want to base the monthly total off of what month PPED falls into. In the end, I want to have one line for each month in 2022. How do I condense the lines? I tried a multi-row tool but some months may have 3 lines(weeks) of payroll data instead of two. I've attached a before and after file of what I'm looking for. Any help appreciated. Thanks!
Solved! Go to Solution.