Transpose Sql Server Rows to Columns

Dec 5 2019 1:55 AM

Hello every one , After a bulk insertion from asp.net c # gridview to Sql server table, I get my data display as image 1 below in my sql server table.

how can i write my sql query syntax to group my data as in image 2 below please, thanks in advance.