core.noscript.text
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Solution:
Sometimes without context it hard to know what solutions will work... I made the assumption that all months will be present (as the solution also need to look at adjacent rows)... and made an alternate solution.
My solution.
my solution
Done !
Completed
solved using Formula Tool string manipulation and multi-row formula tool then joining on a month mapping table
Date with IF statement reformatting are definitely a bit challenging for me.