Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Solution Attached !!
Submission for ADV Challenge 19. solved using Tile tool
I believe that there is an issue with the current version of microsoft, I had to convert the files to XLSX vs xls, but I have solved.
Given there were only two cells, I did two directories and joined them. Learned something new!
1. tool configuration: multi-row. reference the row position with the field name
2. design pattern: use the formula tool 'nullify' non-relevant values before using the summarise tool to extract values of interest with the max function
Less than ideal but it works!