Hi can someone help me to provide a guide or idea on how I can possibly derive this output using the input above. Thank you
Input
Output
This is messy and there may be cleaner ways to do it, but please see the attached workflow.
@Inactive User
will it always be 3 lines for each EmployeeNumber?
@geraldo No there are jnstances employee has more than 3 lines or less than per Date
@cjaneczko Appreciate your help on this. Let me double check on this. Thank you
