Data Transformation for attached use case

[timewaste]

Hello Peers,

Sorry if this is a big ask but I would like to request a solution for following use case attached below. I have tried designing a few workflows on my end with Transpose and Cross Tab approaches over last 2 weeks (pretty much same time I have started using Alteryx) but in vain. Appreciate any support in accomplishing this. TIA!

Looping in Gurus...

@MarqueeCrew @Kenda @JoshKushner @jdunkerley79 @Joe_Mako @JohnJPS 

[Joe_Mako · Accepted solution]

How about the attached?

[timewaste]

Thanks a ton @Joe_Mako