Convert rows into column

[leiferikburoe]

Hi
First I want to say thank you to Alpha5, excellent product.

I think some useful thing will be, to have the option to convert rows into column and opposite,
and view this in grid, and be able to export this to Excel (must be Dynamic)

BR
Leif Erik Buroe

[rnoguera]

SQL servers do this. At least Microsoft SQL servers.
You should use the PIVOT instructions.

Then you can display the data inside Alpha5.

I am using this type of transformation with Alpha5 without major trouble.

Of course having native support for the pivot would probably be more powerful....

[leiferikburoe]

Hi
Thank you for your input, yes I have done some research for SQL,
I was hoping A5 want to implement this V11?

[Stan Mathews]

Created a function some time ago to transpose a table and create a new table from it. Not built in but functional.