mysql - How to produce a result with row and column headers and counts in the middle? (group by 2 fields)

Question

Given a query like

 SELECT x,y,count(*) FROM t GROUP BY x,y

I want to reformat the data to look like:

   null   y1    y2    y3
     x1    1  null    14
     x2    3     4  null
     x3    2     1     5

Is this possible?

Or even if we can omit the first row...as long as I can determine what the colum headers are supposed to be (perhaps with a 2nd query)

(null or 0 for missing count sis fine, swapping row headers/colum headers is fine, top left value can be anything)

Answer 1

If amount of columns is not a fixed value - then it is impossible