This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!
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.