Alteryx Designer Discussions

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

Transpose columns

8 - Asteroid

I'm having trouble understanding the transpose/cross tab tools and I'm trying to convert the results from the first image into something like the second image.


Ultimately I will be adding more data to the table and the Deal_YRMO column will have additional YRMOs (202102, 202103, etc.) with corresponding prices and I would like something that shows up like the second image. Would someone be able to assist? 





15 - Aurora


I added some data and hope this is what you need.


8 - Asteroid

That works - thanks!