How to Use a Loop in the IN Clause of the SQL Pivot Statement for Custom Data Rotation

Mastering dbt Pivoting: A Step-by-Step Guide to Transforming Your Data