Scripting Calculations from Data in Table to New Data Table

[#1]

I have data where I need conditions met and all combinations calculated. How would this need to be scripted? Data Table: Compound Product Value A 1 w B 1 x A 2 y B 2 z New Data Table: Compound Product Test Sum A 1 and 2 w+y B 1 and 2 x+z

[#2]

Hello @JMPUser9 , 

Is it possible for you to provide sample data with examples of correct answers? The example data would make it easier for others to answer.