Tags / unpivot
Handling Null Values and Multiple Columns in SQL Server: Unpivot vs. Cross Apply for Better Data Transformation
Unpivoting Columns with SQL: A Step-by-Step Guide to Transforming Complex Data Formats
Understanding SQL Select Statements: Returning a Static List of Values
Using SQL and UNION ALL to Aggregate Data from Multiple Columns