Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

The latest release includes several enhancements designed to improve your Community experience!

Learn More

Condensing Material and adding rows



New alteryx user! 


I need to reformat my data so that items that repeat themselves in one row are condensed and only show once. Then, the responses form additional columns in the corresponding row. Like this: 




You can use the summarize tool to group by activity and concatenate group and then use the text to column tool to parse out the values using a comma delimiter. 


Hope this helps!

Alteryx Partner

Hi @MNorton014 


Welcome to Alteryx!


I have created a workflow for you which I have attached below. 


I would suggest using the crosstab tool in this case. For the crosstab, I would suggest you use a multi-row formula tool first to create the column headings. 


Hope this helps.


- Andrew

Thank you!