PIVOT the data and display in MVC view

Question

I am trying to display the data in Pivot in MVC view. How to pivot the data by date wise and display the results with header and the values against each result. After getting the data from Procedure I am grouping by Heading and framing the model as follows. My model is as below public   class  ResultModel     {          public   string  ResultName {  get ;  set ; }          public   int  ResultId {  get ;  set ; }          public   double ? Score {  get ;  set ; }          public   string  ResultDate {  get ;  set ; }     }          public   class  ResultGroupViewModel     {          public   string  Heading {  get ;  set ; }          public  List  ResultModel {  get ;  set ; }          }          public  List  GetData()         {             List  resultGroupViewModel =  new  List ();              for  ( int  i = 1; i          {                 ResultGroupViewModel resultViewModel =  new  ResultGroupViewModel();                 resultViewModel.Heading =  "Heading"  + i.ToString();                 resultViewModel.ResultModel =  new  List ();                       for  ( int  j = 1; j              {                     resultViewModel.ResultModel.Add( new  ResultModel()                     {                         ResultId = j,                         ResultName =  "ResultName"  + j,                         Score =  double .Parse(j.ToString()),                         ResultDate =  string .Format( "{0:MM/dd/yy}" , DateTime.Now.AddDays( double .Parse(j.ToString())))                     }); ;                 }                 resultGroupViewModel.Add(resultViewModel);             }              return  resultGroupViewModel;         }     }    I am trying to display the result in view as follows https://i.stack.imgur.com/rgXEU.png

Nitin Sontakke · Answer

Instead of do all this coding here in C# much easier, in my opinion, to do all of this in stored procedure. Where is your data stored? If it is in MS SQL Server, may be I can help. Even otherwise you should consider doing this on server side.   While I am not an expert, the display part should only be a grid, isn't it?