core.noscript.text
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Solution using only the Formula Tool
SPOILER
I learned a couple new things about Data Cleansing with this exercise!
This was easy until the final step. There must be a more elegant way but I did achieve the output result. Thanks!
Here is my solution. Playing around with the Formula tool was fun!
Too easy
My Solution
Please find attached my proposed solution.