Is there any feature in MSSQL similiar to PIVOT table of Excel
I have a detailed table, which has structure as below,
|Column Name||Data Type|
The data stored in the table is as below,
Until my data was in Excel i was easily able to get the output as below, now i had transferred my backend to MSSQL and trying to get the similar output.
Any help will be highly appreciated.