Convert row data to column

Refer the following link : https://stackoverflow.com/questions/17971921/how-to-convert-row-to-column-in-linq-and-sql

0

https://stackoverflow.com/questions/40017880/convert-row-values-into-columns-using-linq-in-c-sharp

http://www.aspforums.net/Threads/973310/Rotate-DataTable-Convert-Rows-to-Columns-and-Columns-to-Rows-using-C-Net/

0

Try using Convert Rows to columns using 'Pivot'

Refer below articles for reference of Pivot in sql

1) http://www.c-sharpcorner.com/UploadFile/8911c4/pivot-examples-in-sql-server/

2) https://www.codeproject.com/Tips/500811/Simple-Way-To-Use-Pivot-In-SQL-Query

All The Best

+1