Alteryx Designer Discussions

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

Cross tab output in single line

8 - Asteroid

Hi , 

I am quite new to alteryx and any help will be much appreciated ,

I am attaching my given input and the desired  output.

I used Cross tab in my workflow , to swap row data to column.

i realised its giving output in different lines. i wish to get the output for one category in single line.

Help me 

16 - Nebula
16 - Nebula

There are two easy ways to do this.


First way is to Transpose and then Cross Tab back


Perhaps the easiest way is just to use a summarise tool and group by and then sum


Samples attached

8 - Asteroid

Thank you so much , this worked perfectly fine.. but if i have some more columns name then how we need to modify the workflow.

Please help.

I am attaching the input and output

Best Regards

16 - Nebula
16 - Nebula

All you need to do is to change the Key fields in the Transpose and Group By field in the Cross Tab