SQL Tutorial - PIVOT

SQL PIVOTS Made Easy (Rows to Columns)

PIVOT - Understanding the Basics in SQL

Two examples to update a column by replacing the value with another value in the SQL Server

Efficiently Replace Multiple Values in a String Using T-SQL REPLACE Function

Update Multiple Columns in SQL with New Values from a Single Query

SQL Tutorial - UNPIVOT

Unpivoting Data with SQL

SQL: Pivot and Unpivot Data in SQL Server Database Including Multiple Columns - A Step-By-Step Guide