Convert row data to column

Question

I have data in my List like below I want to convert that data like this and also Same project should be in same color. is it possible to do it through coding? Can anybody help me I have no idea how to get the expected output. I'm using MVC Linq and Entity Framework.

Rupesh Kahane · Answer

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

Manikandan Murugesan · Answer

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

Rajkiran Swain · Answer

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/