Hi tho,

This is not what I was hoping to see. What is the big question here? Let's make this problem simpler...

See if the added sheet gives you anything close to what you need. I did an UnPivot on your Current data and then Pivoted it using Max and format as date. Does the attached help at all?

Unpivot Lable Filter of Date Max Values Format as Date.xlsx