Can't you use Microsoft Excel Pivot tables if you need it only as a report?
See Tools|Wizards|Pivot Table Wizard

The standard FoxPro Grid cannot do that you want without additional programming.

Just an idea...
If you do not have many rows in your tables, why not "transpose" the table.
This can be done
using temporary cursor,
scan of the table
and adding columns to the cursor from the current Record data.
If you have different types of values, maybe all you fields in the cursor
will be Memos.