Dynamic Unpivoting: A Guide to Transforming Tables with Columns of Different Types

How to Create a Pivot Table in Oracle SQL Without Using Aggregate Functions

Converting Columns to Rows Using SQL Server's CROSS APPLY and VALUES Function