Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved.
Learn more here!
I found the length of the longest amount and pad left with zeros to meet that length and then transformed the data to have each character per ID to have their own column.