Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAdid it two ways - one with a simple filter and one that transposes, appends, joins and uses an updated text input action. both have their merits.
I originally skipped this one as I am not that familiar with app interfaces, but as I have become more involved with macros this seems more straight-forward
I used a very different approach to the solution to come to the same answers.
I chose to create a key field with some parsing and multifield formula involved.
See solution in pic and attached.
To avoid manually set the drop down value
1. Use 4 select tools to rename all the fields to be the same name (e.g. position number, key, etc) and then union these four streams into one column.
2. Use cross-tab to turn this key column into separate field names
3. Feed these field names into the drop down tool
1. Use 4 select tools to rename all the fields to be the same name (e.g. position number, key, etc) and then union these four streams into one column.
2. Use cross-tab to turn this key column into separate field names
3. Feed these field names into the drop down tool
Above is the method to avoid manually listing the drop down selections