Howdy,
I've built a workflow that creates the output you can see in the "Current Structure" file. What I'm trying to do is get to the "Desired Structure" I've manually created.
In the transpose example, it shows a combination of transpose and cross tab tools being chained together to get to the desired output. I assume that been the transformation tools and possible a multi-row formula this can be done but I'm pretty new to Alteryx and I'm drawing a blank. I'm pretty new to Alteryx, previously I would have used formulas in excel to manage this.
Any help would be much appreciated!
-Luke
