The problem is that I was given a bad data design in the first place, and I didn't question it until the end of UAT. I'll just bite the bullet and redesign the data.