My friends and me are playing some online card games. That is game for 4 players and at the end server saves result of all games. I can copy all games in excel and I already did some adjustments of data. For example, I got results in this format:
0-2336555 // unique number of game
John 12
Ana 25
Dana 33
Peter 36
For result we got points for each games (10-6-3-1). I have all of that sorted as it can be seen in example in attach. Now, we want to know mutual score between two players.
On some our forum nice people helped me and I got that in excel in Power query (SHEET Poredjenje in my workbook). But, there is only counted score for results on the end of game (John - Ana; 12 -25; it means 1-0 for John) but I want also to know how many points got each player in mutual games (John - Ana; 12-25; 10 -6 in upper example) and I want it in Access.
