Display Grid Columns Vertically (Transpose Grid)

[Pinal]

Hi,

I have a requirement in my project to transpose a grid (i.e. displaying tabular data in the flip axis so rows becomes columns and vice versa).

For example: Below is the data we typically display in kendo grid. It has 3 columns : Name, Age and City

Name             Age      City
John             35       New York
Brian            37       London
Tom              38       Phoenix

 

I want to display above data in below manner: 

Name    John        Brian   Tom
Age     35          37      38
City    New York    London  Phoenix

I noticed a server side solution of what I am looking for in a teleric blog (http://www.telerik.com/blogs/transpose-or-just-rows-as-columns), however I am looking as client side solution for it as rows will be added dynamically at run time on client event.

I also found few solutions on internet which partially solve the problem but they require to destroy the grid and then creating it all over again which I don’t want to do as I will lose existing unsaved data.

Please let me know if it’s possible to achieve using Kendo Grid.?  We use KendoUI for ASP.NET MVC and Kendo UI for HTML5.

[Boyan Dimitrov]

Hello Pinal,

 

I am afraid that such functionality can not be achieved with the KendoUI for ASP.NET MVC or Kendo UI for HTML5.

 

 

Regards,
Boyan Dimitrov
Telerik

 

 

[Jenny]

Any  update on Pinal's question as on kendo updates currently? In my project also, I am coming across the same scenario  . 

Thanks in Advance, 

Jenny

[Boyan Dimitrov]

Hello Jenny,

Unfortunately there are no updates about Pinal's question and this functionality is not implemented in the Kendo UI Grid widget. 

Regards,
Boyan Dimitrov
Telerik by Progress

[Walter]

Hello,

Is there any update on this issue?
Thanks in advance!

Regards

[Viktor Tachev]

Hi Walter,

The functionality is not built-in for the Grid component. However, you can implement the feature using custom code. Please check out the resources below that illustrate how you can transpose the Grid rows.

• https://docs.telerik.com/kendo-ui/knowledge-base/transposed-grid
• https://www.telerik.com/blogs/transpose-or-just-rows-as-columns

Give the suggestions a try and let us know how they work for you.

Regards,
Viktor Tachev
Progress Telerik