4
https://www.sqlshack.com/multiple-options-to-transposing-rows-into-columns/
4 Please refer below links
https://www.codeproject.com/Tips/1166949/Convert-column-into-rows-without-using-pivot
https://stackoverflow.com/questions/49761712/sql-server-how-to-transpose-rows-to-columns-without-pivot-or-unpivot-or-aggrega