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.