sqlite: How to create a 2D array from SQLite table in Android

lundi 28 mars 2016

I have a table in SQLite with the following:

PNO EVENT   TOTAL
2   A       3
2   B       2
2   D       1
3   A       4
3   D       2
4   A       3
4   C       2

How can I get a 2D array like the following:

        Events  
Players A   B   C   D
   2    3   2   -   1
   3    4   -   -   2
   4    3   -   2   -

sqlite