Pivot a csv file.

Question

i want to read a csv file using oledb and pivot it and export to csv..

Dipal Choksi · Answer

Approach 1 - You should be able to read the csv file to a datatable and then use the .net code from one of the following links to pivot it and finally write it back to a csv http://michaeljswart.com/2011/06/forget-about-pivot/ http://joyi-john.blogspot.com/2008/07/simple-pivot-table-using-datatable.html http://masterindotnet.blogspot.com/2012/08/create-pivot-table-in-c.html http://weblogs.sqlteam.com/jeffs/articles/5091.aspx Approach 2 You should be able to read the csv into a datatable and then write you own function to process it line by line or through an array/collection.. and then write it back to csv. HTH...