sql - Suggest ways to convert Rows into columns -

i have excel file has 3000 rows. want convert part of these rows columns. there macros or can done in sql server? please suggest.

below sample data:

this has converted below:

typically, 2 things: 1. column names added , existing have names changed. 2. record count huge, headers names must shown in picture. 3. part of rows converted columns. there's glitch. suggestions helpful.

this done pivot (there's unpivot).

https://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx