Transpose Excel data from rows to columns or vice versa

Question

Greetings!I am currently using ExtractDataTable function to show content of Excel file in my SfDataGrid.Is there a possibility to transpose rows into columns and backwards?Best Regards,Aleksander

Konduru Keerthi Konduru Ravichandra Raju · Answer

Hi Aleksander, 

Greetings from Syncfusion. 

We have prepared simple sample to Transpose the rows and columns in a DataTable. The sample can be downloaded from the following link. 

Sample Link: https://www.syncfusion.com/downloads/support/forum/149194/ze/F1491941736666187.zip  

Kindly try this and let us know if your requirement is fulfilled. 

Regards, 
Keerthi.

Aleksander Zotov · Answer

Thank you very much!This worked as charm.Best regards,Aleksander

Konduru Keerthi Konduru Ravichandra Raju · Answer

Hi Aleksandar, 

Thanks for the update.  

We are glad that your requirement is achieved. 

Regards, 
Keerthi.