Someday Postgres will get support for PIVOT/UNPIVOT, but today is sadly not that day. https://learn.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-

Someday Postgres will get support for PIVOT/UNPIVOT, but today is sadly not that day. https://learn.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot https://learn.microsoft.com/en-us/sql/t-sql/queries/from-usi... https://blogs.oracle.com/sql/post/how-to-convert-rows-to-columns-and-back-again-with-sql-aka-pivot-and-unpivot https://blogs.oracle.com/sql/post/how-to-convert-rows-to-col...