Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution:
Thanks for the solution @alex. I am new to Alteryx. I came across the PadLeft function for the first time through this challenge. Making use of this function made it very easy. I initially started doing it by using Filter and Formula tools to split each value into a separate column. This was very time consuming and I was still getting error.
Did a double time conversion to avoid strange formulas lol