Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEASolved this a while back, not sure why I haven't submitted it before, but here it is
Still Climbing
/Verakso
Not an elegant solution but gone the work done.
Will have to understand the solution provided.
There are many new functions included in the solution like Regex Replace.
Great challenge on how to clean and restructure a table.
Lessons to learn:
1. use of Transpose and Cross-Tab
2. restructuring by e.g. Filter + Join Tool
3. filling in Nulls with the Multi-Row Formula Tool