Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMine is similar to the posted solution, although I included a few unnecessary steps!
Good Challenge. I learned something new about the Crosstab tool and about Regex. Mind you, the days when I don't learn something about Regex are few and far between.
This was our challenge of the week in our internal user group. Since I'd already done this challenge, I decided to refactor my original workflow to eliminate the parallel processes for each word.
Used the multi-row tool and row by row replacements with summing dropped letter counts... a bit different!