Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
All,
My solution is below:
Spoiler
Okay, so I wanted to use only the core tool set.
-I used 2 RecordIDs, 2 Text to Columns, a JOIN, a Union, Crosstab and a Find and Replace.
-One thing that I did on the CrossTab was to use Pipes vice commas, as this allowed for easier separation vice using the default comma.
-I used 2 RecordIDs, 2 Text to Columns, a JOIN, a Union, Crosstab and a Find and Replace.
-One thing that I did on the CrossTab was to use Pipes vice commas, as this allowed for easier separation vice using the default comma.
