Grouping data by hierarchical values in one column

jensroy

I am stuck at something that seems should be very simple to solve, to group data by parent value in the same column.

I would like one Column per value in the column "Breakdown". The column named "Breakdown_level" indicates which level of a hierarchy the row is in. There will be a variable number of breakdown_levels, as well as variable values in the "Breakdown" column.

Any ideas on making this data more database friendly would be great!

See sample of the data i have and where i want to end up in the attachment.

Grouping challenge.yxmd

Joe_Mako

Attached is another route:

In the Macro:
- Macro Input set to Show Field Map
- Filter to keep only the current Iteration Level number
- Select to keep only relevant fields and rename with underscore (for replacement later)
- Join Multiple so all records are kept as the two new fields are added in
- Sort to ensure proper sort
- two Multi-Row Formula tools to fill in the values where row's level is greater than the current iteration
- Dynamic Rename to replace the underscores with the Level/Iteration number
- Filter to send out the completed records, and Loop back in the remaining level rows

Grouping challenge jm edit.yxmd

Breakout Level Value.yxmc