This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
Thank you! I never would have thought excel would have been detrimental but I think some of the logic I've used in the past actually makes transitioning to this more effective solution harder than it needs to be! Looks like I have lots of practice in store...