Transposing Rows->Grids and vice versa

[Mikael]

Just checking if this would be doable:

We have a need to transpose the content of the RadGrid, i.e. make columns in the source data become rows in the RadGrid, and vice-versa.
I know I could do this "manually" be transposing the source datatable, but I wonder if there's any support for this built-in.

Thanks!
/Fredrik

[Princy]

Hello Fredrik,

You can go through the following online demo which demonstrates how RadGrid can be bound to pivot table when you want to display the data in a reverse order but still keep the same presentation and structure in the source table.
Displaying pivot data

For more information on this you can also go throught he following help article.
Binding to Pivot table

Thanks
Princy.

[Rakesh]

Is there a way to manipulate the data when we transpose the rows to columns? 
i.e I want to give the user a Excel like interface with transposing the rows to columns and vice versa. Is this possible?
Thanks
Rakesh

[Konstantin Dikov]

Hi Rakesh,

With the current implementation of the RadGrid, transposing rows and columns (displaying pivot data) is supported only in display mode and no edit functionality could be achieved.

As you could see in the help article, once the DataTable is retrieved, it is being rotated, so it could simulate transposing between the rows and the columns.


Regards,
Konstantin Dikov
Telerik