How to transpose rows and columns in a KendoUI grid?

[Joonu]

Hi Team,

I wish to display statistical data for multiple countries in my grid. The way I retrieve data from the database, my grid would show data a bit like the following:

Country    Area(km^2)    Population        GDP($ trn)    GDP Growth (%)    Inflation (%)
India          3288000         1220200000       1.848             6.8                           7.9
USA          9827000          314686189         15.09            1.7                            2.0
.
.

But instead of the format above, I wish it show like the following:

Country                    India                USA                .
Area (km^2)             3288000          9827000         .
Population               1220200000    314686189     .
GDP ($ trn)              1.848               15.09              .
GDP Growth (%)      6.8                  1.7                   .
Inflation (%)              7.9                  2.0                  .

Please let me know how I could achieve this transposition.

[Vladimir Iliev]

Hi Joonu,

 
Basically transposing of the Grid currently is not supported out-of-the-box, however you can implement custom solution for example by transposing the data manually on the sever side and send it to the Grid. 

Also you should share your idea at the Kendo UserVoice to allow other users vote for it. Most voted ideas are included in next KendoUI releases.

Kind Regards,
Vladimir Iliev
the Telerik team

[Diga]

Hi Vladimir,

Does this solution (http://blogs.telerik.com/xamlteam/posts/09-02-16/transpose-or-just-rows-as-columns.aspx) works for Kendo UI Grid? If not, is it possible to achieve it using Pivot Grid?

 I would appreciate if you can provide me with some sample code (either using Grid or Pivot Grid).

Thanks!

[Vladimir Iliev]

Hello Diga,

Yes, the linked extension method can be used for transposing the Grid data on the server side.

Regards,
Vladimir Iliev
Telerik