community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Condensing Material and adding rows

Highlighted

Hello! 

 

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: 

 

Thanks! 

Alteryx
Alteryx

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!

Labels