how to sql query transpose

For this there is a multiple options to transposing in SQL You can use pivot, cursor function. Check out below links it will help you. https://www.sqlshack.com/multiple-options-to-transposing-rows-into-columns/ https://www.google.com/amp/s/tothecore.sk/2019/01/24/transpose-rows-into-columns-in-ms-sql/amp/