Using SQL and UNION ALL to Aggregate Data from Multiple Columns

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

Unpivoting Oracle Tables: A Step-by-Step Guide to Multiple Columns