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.
In my attach:
-Start sheet is "raw" data from game. Just copied and pasted
-Than I made with power query sheet ListaIgraca where are Unique players
-Also Sheet rezultati is modified and adjusted from Start. I did it with Power query
-Poredjenje is final sheet and I want to get that on Access now. Also I want to add "Bod" value. Now, I only have "Skor" value for both players