@rfarmenta
I'm still not 100% sure that I understand what you need. What would really help: Add your Have sample data and the desired want result using the sample data (a table or another data step creating the desired data) into a single post and then explain the logic how you get from the have to the want.
... View more
