Today I received a very unusual data request and thought I can get some help from the community again. I tried to imitate a similar logic to come up with the exact work scenario. I have table A, B, & C below. Vendor needs information in a specific format as I have at the very bottom on Result section. First field on Result needs to be hard coded letters. D stands for demographic, R for revenue, and P for Procedure. Any solution or advice is greatly appreciated.