Send the following on WhatsApp
Continue to ChatPivoting data without an aggregation column https://obscureproblemsandgotchas.com/development/sql-server/pivoting-data-without-an-aggregation-column/
Pivoting data without an aggregation column https://obscureproblemsandgotchas.com/development/sql-server/pivoting-data-without-an-aggregation-column/