@JoeM the link does show https://community.alteryx.com/pvsmt99345/attachments/pvsmt99345/weeklychallenge/549/1/challenge_63_R... However, the when clicking on it I see XML Code. I am using i.e 11. I will try it with another browser.
I added the file initially using IE11... just re-added it using Firefox, and the link appears to work correctly now opening from any browser... so I guess in the future, I will NOT be using IE11 to add files! Who knew?? :)
If we ignore the requirement of making this data driven, and allow for a manual workflow, then this can be done in as little as two tools:
- Select Records to remove all the headers
- Arrange manually configured to do all the reshaping
I then took on the challenge to make the Arrange tool data driven for this situation, no cross tab or transpose tools, and practiced writing XML to configure the tool in a macro.
Finally, I made a workflow similar to @patrick_digan