Arrange column and rows

[Inactive User]

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

 

[geraldo]

@Inactive User 

will it always be 3 lines for each EmployeeNumber?

[Inactive User]

@geraldo No there are jnstances employee has more than 3 lines or less than per Date

[cjaneczko · Accepted solution]

This is messy and there may be cleaner ways to do it, but please see the attached workflow.

[Inactive User]

@cjaneczko Appreciate your help on this. Let me double check on this. Thank you