Efficiently Unpivoting Multiple Columns into Name and Value Pairs in SQL

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

Unpivoting Rows to Columns: A Cross-Database Solution for Transforming Data