I am not sure. Have you tried to search for PIVOT on UT?

>It seems that it is using MS Excel objects...
>I don't have MS office installed...
>Is there any other way?
>
>
>>Check out wzpivot.app and appwiz.prg in the wizards directory of VFP8
>>
>>>Suppose I have such data:
>>>Month, Customer, Amount, Sum
>>>
>>>I need report like MS Excel Pivot Table:
>>>Customer, Amount_Month_1, Sum_Month_1, Amount_Month_2, Sum_Month_2, etc.
>>>
>>>Is there any command to solve this task in VFP8?
>>>
>>>Or I have to code this manually?