Transpose Excel data from rows to columns or vice versa

[Aleksander Zotov]

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]

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]

Thank you very much!

This worked as charm.

Best regards,

Aleksander

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Aleksandar, 

Thanks for the update.  

We are glad that your requirement is achieved. 

Regards, 

Keerthi.