>>>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)?