Transform Data

[SandyCovey]

Hi

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. 

[rzdodson]

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

[SandyCovey]

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

[rzdodson · Accepted solution]

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

[SandyCovey]

Thanks @rzdodson this is excellent, really appreciate it