Alteryx Designer Discussions

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

How can I change the orientation of a row to a column showing sales in one row

8 - Asteroid

I need to transform the orientation of my data from displaying sales, units, margin by row into one single row.  Below is example.




Need to look like this 





Alteryx Certified Partner

Hey @HeadBanger !


You can use Crosstab tool from the transform group to do that job. 



Alteryx Certified Partner
Alteryx Certified Partner

Hi @HeadBanger 


I would do the following,

1. Formula tool to concatenate Name and Target

2. Crosstab tool to get everything in a single row. No need for a group by any fields. Just have the header as your concatenated field and value as Value.



8 - Asteroid

Hi Philip,


You da man.  Thanks!  This worked.  I was missing that concat part for name and target.