Hi,
I'm trying to create workflow to transform data and assign levels to each records based on ownership structure. And I'm hitting roadblock when using Multi-Row Formula & Join tool and not able to proceed further
What I'm trying to achieve-
1. If there are multiple owners for a record (rows 21 from the attached excel - Sample Org Chart Data).
1.1 I need to add a row & duplicate data in columns A thru F and fill in columns G thru I with data from columns J thru L
1.2 I need to add a row & duplicate data in columns A thru F and fill in columns G thru I with data from columns M thru O this same process to repeat if there are several owners.
2. Need to assign Level/Tier to each record based on the position of the record in the org structure. (from the attached excel - Expected Result tab has this result)
3. Need to assign OwnerLevel/Tier to each record based on either "OwnedBy" or "OwnedByID" data( the (from the attached excel - Expected Result tab has this result)
Thank you!
Bharat S
