If your data is readonly, you can fill the data in php array and then transpose php array (try searching google / stackoverflow). Then load transformed array to grid using following demo.

Code: https://www.phpgrid.org/demo/demos/loading/load-array.phps

Demo: https://www.phpgrid.org/demo/demos/loading/load-array.php

Thank you Abu,

but I have a bit detail. the date column increases, it’s not static. And I will have to use the horizontal scroll.

Send me the source data (or sql table structure) which you need to be transposed.

I’ll try to create a demo and send you.

You can email me at [email protected]

I think you should think the other way around. Change columns by rows and rows by columns.
Horizontal scroll moves with record and vertical scroll with fields.

It’s like turning the screen. Horizontal to vertical.

I understand better now. I think you are looking for this:

https://www.jqueryscript.net/demo/Transpose-Table-jQuery-Plugin/
https://github.com/riteshgandhi/jquery.table.transpose

OR

https://stackoverflow.com/a/25797426/8743891

Both above solutions are not supported with our grid right now. Basically the problem is the underlying structure of grid is not just <table></table>. it’s little complex so transpose function will be difficult and need core level changes.

Thank you a lot of!

You are cool!