Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere is my solution. Definitely loved this one! I had to do something similar in SQL to build an HR table for my work. I ended up using a series of left joins in SQL but it was really fun to see this applied outside of database.
I am still mastering the macros in general. The solution seems to have a few less tools in the macro. I think I made mine a bit too complicated, unnecessarily but appreciate the simplicity of the solution. Also I ended up assigning hierarch using a multirow formula, instead of leveraging the iteration number.
Sleak solution overall and fun problem!!!!
Thanks for the opportunity to learn!
Here's my solution, realised I had done this one a few weeks back but it wasn't on my Google Sheet where I am monitoring how many solutions I've completed.
Sam :)