Transform Data

I require to transform some quarterly reporting into a more useable format for our purposes - report format is excel.

I've attached file with sample data and required data output.

Accepted answers

@SandyCovey try this out. This should get you close to what you are looking for.

@SandyCoveyare we solving for just the three employees, or are you needing it to be dynamic and handle more?

I need this to be more dynamic, including more employees and departments

@SandyCovey try this out. This should get you close to what you are looking for.

Thanks @rzdodson this is excellent, really appreciate it