PivotDataTablePrj a 3rd party to convert flatten data to Pivot data table see this unit test: https://github.com/mbs220/PivotDataTablePrj/blob/master/MBS.PivotTest/UnitTest1.cs Also See Wiki: https://github.com/mbs220/PivotDataTablePrj/wiki