Hi all,

Is there a best practice to transpose data in VFP based on a column or columns

Example: Transpose data by F4, then F1
Table1
F1   F2   F3  F4
AAA   1    1  8/22/02
AAA   2    1  8/22/02
AAA   3    1  8/22/02
BBB   1    1  8/22/02
BBB   2    1  8/23/02
CCC   3    1  8/23/02

Result:

F4       F2 F3AAA F3BBB F3CCC 
8/22/02   1     1     1     -
8/22/02   2     1     1     -
8/22/02   3     1     -     -
8/23/02   2     -     1     -
8/23/02   3     -     -     1