Converting Excel Data as shown below

Question

I want to convert below data using SQL or C# or Excel

 

 I want to convert above data Like this, This is sample data in my scenario i have to convert Thousands of data

 

 

Please Help me