title: .NET Winform - Pivot Table for multiple Data Value columns
body: <p>I need to create a pivot table at the front end after retrieving data from the DB in a datatable and need to update the values of my grid with this data. </p>
  
  <p>I have gone through many articles/blogs but they all demonstrate it by using one Data Value column. But in my scenario, I have <strong>8 Data value columns</strong> to be pivoted.</p>
  
  <p><strong>Data To Pivot</strong></p>
  
  <p><img src="https://i.stack.imgur.com/PYNcm.jpg" alt="enter image description here"></p>
  
  <p><strong>Pivoted Data</strong></p>
  
  <p><img src="https://i.stack.imgur.com/eTz3G.jpg" alt="enter image description here"></p>
  
  <p>Do someone has idea how to do it efficiently at the front end?</p>
  
  <p>Would it be a good idea to embed the data in excel, create the Pivot there and retrieve the required data from excel?</p>