Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAhi,
Please find my solution below.
I'm unsure whether just selecting rows is considered cheating, but i got there in the end. There was also, by my knowledge no way to identify which data belonged to which code/program.
Completed the challenge using mostly select tool and filter. Thought I would need to transpose, but didn't in the end
Were you able to figure out REGEX? If so, can you explain the function REGEX_Match([Field_2], '^\d.*')