SQL data transformation query

SQL Server Administration
1

How to convert long data to wide data in SQL without doing hard coding?

Regards
Manish Bose[Preformatted text](https://www.allaboutsql.tech/)

2

using unpivot:

Using PIVOT and UNPIVOT - SQL Server | Microsoft Learn