Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
I get the same info but the columns are not in the same order, but I cannot find any rhyme or reason to the column order of the answer. I suppose I could manipulate the order of the answer, but that seems pointless (and kind of like cheating)
Spoiler
Process:
- Concatenate Category, Subcategory, and Description (allowing for nulls in the Subcategory)
- Transpose data in lower thread
- Join data
- Sort results by Name (not needed but part of my heroically feeble attempt to match the answer column order
- Cross-tab back
- Dynamic rename (since cross-tab seems to add underscores) to replace Header
- Remove unneeded column
- Concatenate Category, Subcategory, and Description (allowing for nulls in the Subcategory)
- Transpose data in lower thread
- Join data
- Sort results by Name (not needed but part of my heroically feeble attempt to match the answer column order
- Cross-tab back
- Dynamic rename (since cross-tab seems to add underscores) to replace Header
- Remove unneeded column
