I have a project for redoing an org structure. I have attached example data - the actual data is thousands of rows.
The organization goes from Tier 0 down to Tier 7, with the Type columns giving a description of that each tier is. The current workflow I have already successfully adds new lines to the org and renames levels based on a change file input.
The new ask is to add a move step and a delete step.
The move step would take an existing org level and change it's parent (Tier 0 being parent to Tier 1, etc). It might stay at the same Tier, but it also could change tiers.
The delete step would remove a group from a cell and also its description from the Type column associated. The added complexity is that it would need to collapse - if I have a row that goes down to Tier 6, and they want to delete the org group in the Tier 4 column, Tier 5 and 6 would shift up and become Tier 4 and 5 along with their respective descriptions in the Type columns.
