Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAIn my solution, I swapped the Formula (Trim) for a Datacleanse, the Samples with Select Records, and integrated the Dynamic Rename tool. I realized my use of the Record ID tool and subsequent Transpose and Crosstab tools were not as efficient as they forced me to add the Dynamic Rename later on. These challenges are really helping me improve! 🤠
In scanning others' posts, I see I used find/replace instead of Join. Interesting to see the variety of solutions!