Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAtakeaway
1. tool: multifield formula. apply the same logic to multiple fields on a conditional if statement.
2. design pattern: record id preceding transpose tool to keep track of position post transformation
3. shortcut: right-click on on field and drag to reorder in the config pane of the select tool
my solution
Solution is attached
Holla,, see my result..