We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
Weekly Challenge
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit Feedback
Perfect use case for the Crew Macro - Dynamic Formula.
A lot more efficient than other ways, especially if we were to be playing with more than 100 rows of data.
Also keeps the field order as well.
Take a look into the macro - it's modifying the XML, kudos to @AdamR in creating this years back!
Nice challenge. Tricky getting the output column order correct.
Spoiler
I went the transpose-join route as opposed to using an append fields/formula combo
I got the column order correct by using the Data dictionary record ID as the key in the Cross tab. These get sorted into the proper order then it's a dynamic rename
I got the column order correct by using the Data dictionary record ID as the key in the Cross tab. These get sorted into the proper order then it's a dynamic rename
Dan
