Sad 
… was worth a shot though!
Then I guess it’s depending more on the database you use than Metabase itself. For example Postgres has crosstab:
https://www.postgresql.org/docs/9.6/static/tablefunc.html
(found via Pivot the result of a SQL query BTW, so thanks there I also learned something)