You could use a cross tab query and use the record number as the unique key required for it to work.



>Hi,
>
>Can you use sql to transform a dbf table with fields like "code" and "Value" so I get each "code" as a column?
>
>Transform records like
>A1 123
>A2 234
>A3 345
>
>to
>
> A1 A2 A3
>123 234 345