Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Reformatting/Transforming Data

Hey Everyone,


I have some data that I'm trying to reconfigure so it is better suited for Tableau.  I've tried out transpose and crosstab and haven't been able to get the result I want. I feel like I'm overthinking the issue at this point. I've attached a photo of what I'm trying to accomplish and a photo of my current workflow. Can I accomplish this tasks with some combination of formula tool (add new column) and transpose or cross tab?


alteryx excel example.PNGfile drop.PNG



Yes this is doable




Use a transpose tool to flip it to be rows and then you can use a find and replace to change the original headers to what you need.


Sample attached