SQL PIVOT and UNPIVOT: Reshape Rows ↔ Columns for Analytics

sql pivot turns long-format rows into wide-format columns: one row per category becomes one column...