Alteryx Designer Discussions

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

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? 

 

crtakacs_0-1610584671318.png

crtakacs_2-1610585514981.png

 

15 - Aurora

@crtakacs 

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

0114-crtakacs.PNG

8 - Asteroid

That works - thanks! 

Labels