I resolved this from scratch as it was almost a year ago that I first solved this real-life challenge. Much more efficient workflow now. I use this as an example of the power of Alteryx. This used to be a manually copied to Excel process from multiple files that took about 10 hours to complete for over 1500 lines. Now it is seconds.
Talk about a real life example! I never would have figured this out from the instructions without seeing the output. This is why when anyone asks for help on the discussion boards we always ask for sample input and sample output.