Creating Columns from Row Data

[mazeem]

I need help with creating a workflow for the attached data set to look like this in Alteryx? Column headers: Account #, Group, Subgroup, Description

[Luke_C]

Hi @mazeem 

You can use the multi-row formula tool to help with this:

1. I used multi-row formula tools to find the rows that started with 'Group' or 'Subgroup'. Then was able to repeat those values in a new column until it came across the next group/subgroup
2. I filtered to just the rows with account numbers
3. Renamed the fields.

[mazeem · Accepted solution]

Very helpful thank you!!!

[Luke_C]

@mazeem  Happy to help - be sure to mark it as solved.