>>>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)?
George
Ubi caritas et amor, deus ibi est