Hi,

I have a form which searches database on user critera and displays the result in FlexiGrid and if user wants to export the result to excel they can. Everything is working fine. But now I want to modify this program a little.

The result in Grid is display like this:

Year-----Field1-----Field2-----Field3
2000----- A ------- A -------- A
2001----- B ------- B -------- C
2002----- C ------- C -------- C

But I want this to be displayed in Grid like this:

Year----2000-----2001----2002
Filed1----A--------B-------C
Field2----A--------B-------C
Filed3----A--------B-------C


How can I do this? Any help?

Thanks