>>>>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
Mathias Banda
Time is longer than a rope.