This was a good example of how a data can be restructured and I am sure there are multiple ways to do the same. Attached herein is my attempt and believe results are good.
Let me know if anyone knows the better way to optimize with large data.
this one required some head scratching
TA
1. RecordID to the left of the transformation to keep tabs following output
