Pivot a table with 3 coulmns with two layers of header columns

Hi:

I have a table with 3 columns as below:


ENTITY ID      GROUP_NAME      SCORE_NAME
A-001            G1            GOOD
A-001         G2            BAD
A-002            G3            VERY GOOD
A-003            G1            GOOD
B-001            G4            BAD

I would like my excel data to look like:
      


                        G1        G2                G3            G4
ENTITY_ID     VG G B   VG G B   VG G B  VG G B
A-001               1                      1
A-002                                             1
A-003                 1
B-001                                                            1

I have figured out how to pivot on the entity_id and the group_name, see below, but also need the SCORE_NAME somehow with its score (=existential count).


TRANSFORM Count(GROUP_NAME) AS CountOfNAME
SELECT ENTITY_ID
FROM myTable
GROUP BY ENTITY_ID
PIVOT GROUP_NAME;