Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere's my solution!
solved
Would have use a formula to select regular or diesel - liked the transpose tool use instead of using a formula later in the workflow.
Each data file had a different data challenge. Good one! I rarely use find/replace. Good instance to use it.
Here's my solution.