Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEATook a slightly different approach and created a lookup table with Delimiter & Score Values
-Find and Replace score values to get delimiter inserted between scores
-Text to colums to split scores to rows by round
-Find and replace Score with actual value
-Modified case once score was brought in to sum total score per player per round
I found this challenge a little difficult.. and I also end up using two tools that I rarely use - RegEx and Multi-Field Formula... anyway got to the answer finally!