Split data help

[Joggy1122]

Hello,

I'm trying to create a auto calculation for the return/loss of each person, but I tried so many times, still cannot make it. 😭😵

The example is the excel

I want to have the result like 

         Poker  Dice  Roulette  Craps

Tom   -150     90   80           -80

Jane  -250     440   150         -450      

Ben    900    -430   -20         20  

Anna  -100     380     -10      0

Thanks and much appreciated for your assist. 

[Felipe_Ribeir0 · Accepted solution]

Hi @Joggy1122 

Take a look at the attached workflow.