Create Field Based on Order of Records

[bsolove]

In the file attached, I have three instances of each state for each company.  For each state, I'd like to create a column where the first instance of each state says "Addition", the second instance says "Subtraction" and the third instance "Post-Apportioned Adjustment."  There are duplicates of each state when the entity name changes.  Can someone please provide some guidance?

[jarrod]

See attached. it's basically a multi-row tool (grouping the main pieces) to get the field order, then a crosstab to roll up horizontal, then a select to rename the fields.

[bsolove]

Thanks very much.  I can't open your workflow because I am running on an older version of Alteryx.  Could you send me a screenshot of the multi-row formula and the cross tab tools?

[jarrod · Accepted solution]

no problem.

here's the multi-row:

and here's the crosstab:

The select:

And the workflow:

[DiganP]

@bsolove Attached is the workflow that does what you asked for. Is this what you are looking for?