Here is a formula solution as in :
1] In "Output" G4, formula copied across to J4 and all copied down :
2] In "Output" K4, formula copied across to P4 and all copied down :
I'm going to repeat my response to Carim to you...
First, I would like to thank you for your time! It is much appreciated. Second, I would like to apologize for my extreme delay in responding. Priorities shifted, and I wasn't able to commit time to this work.
After I started entering my data into the spreadsheet, my results weren't matching what I wanted. Your macro and formula were perfect. My input was not. In trying to simplify my request, I omitted information.
In the output table, columns 'Team - Level 2' thru 'Team - Level n' could have duplicated values similar to 'Team - Level 1'. In the attached file, I've highlighted the new example in purple. Again, this scenario could occur at Level 2 thru Level n.
Please let me know if I'm unclear. Thanks again!