Tags / unpivot
Unpivoting Oracle Tables: A Step-by-Step Guide to Multiple Columns
Converting Columns to Rows Using SQL Server's CROSS APPLY and VALUES Function
Unpivoting Columns with SQL: A Step-by-Step Guide to Transforming Complex Data Formats
Unpivoting a Query in Presto to Get Column Names Based on Condition
How to Create a Pivot Table in Oracle SQL Without Using Aggregate Functions