Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Nice! Tried to take a route using a lookup table via generate rows:
Submission for ADV challenge_21_ Adv data Prep using Text to column, find replace and multirow
Last challenge today!
I used some batch concepts leveraging the multi-row... curious on how others tackled as well.
Here's my solution.