How make pivot for sql data table

Refer this links

https://blogs.msdn.microsoft.com/spike/2009/03/03/pivot-tables-in-sql-server-a-simple-sample/

http://stackoverflow.com/questions/9981120/create-a-pivot-table-from-a-datatable

it may help you

Please go through:

http://sqlhints.com/2014/03/10/pivot-and-unpivot-in-sql-server/

https://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/

Follow below link that may help you:

https://www.aspsnippets.com/Articles/Export-Windows-Forms-DataGridView-to-Excel-using-C-and-VBNet.aspx

https://www.codeproject.com/Tips/545456/Exporting-DataGridview-To-Excel

refer this link

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