Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAtry attaching the workflow with one liner comment as it is advised for the weekly challenges
Nice! This took me back to my last job, having to filter and sort uneven columns of data. Many hard lessons using the Transform palette.
I had a different approach that most people here. The first thing I thought of when I saw this problem, was that it could be solved using just one formula tool. Although it is not future-proof, in case new columns are added, it answers this problem using the minimum number of tools.