Create temp table and Convert row values to column values and insert temp table using stored procedure

Transact-SQL
1

Hi,

I want to convert row values to column values and insert into temp table using stored procedure. Image attached for your reference. selected data only to convert.

Advance Thanks!

image

2

Any ddl or sample data you can provide?

3

if you have enough experience to follow the below article and do it yourself

https://www.sqlshack.com/multiple-options-to-transposing-rows-into-columns/

if not please let me know