>>>>Hi there! Need help. Is there a way of transposing data in foxpro? You know more or less the way you just transpose a range of data in a spreadsheet application.
>>>>
>>>>I would love to transpose my data into some temp cursor so that column 1 becomes the first row / header before I pull the data in a report.
>>>>
>>>>
>>>>Thanks
>>>
>>>Hi Mathias,
>>>
>>>Do you mean that you want to, for want of a better term, "un-cross tabulate"?
>>
>>Hi George,
>>
>>I don't quite follow. What do you mean?
>
>Hi Mathias,
>
>Take the following for example:

>        Column 1     Column2     Column 3
>Values     A            B           C
>  D        1            2           3
>  E        4            5           6
>  F        7            8           9

>The above is refered to as a cross-table, and can generated by the program pointed to by the _GENXTAB system variable. Normally the source looks like this:

> FIELD1 FIELD2 FIELD3
>  D       A     1
>  D       B     2
>  D       C     3
>  E       A     4
>  E       B     5
>  E       C     6
>  F       A     7
>  F       B     8
>  F       C     9

What I was asking, was are you trying to get from the cross-table (the first example) to the table (second example)?


No exactly but if you take the second example here what I wanted was to get
FIELD1 FIELD2 FIELD3 FIELD4 FIELD5 FIELD6 FIELD7 FIELD8 FIELD9
D D D E E E F F F
A B C A B C A B C
1 2 3 4 5 6 7 8 9

Thanks