>I have a table that has the following fields and data
>
>oldtable
>
>Field_name Data
>Firstname John
>Lastname Smith
>Phone 555-1212
>Firstname Peter
>Lastname Johns
>Phone 555-1252
>
>I would like to change the dat to look like this
>
>newtable
>
>Firstname Lastname Phone
>John Smith 555-1212
>Peter Jones 555-1252

Not sure what you are wanting to do. If you are wanting to take old table and replace it in the new table in a different format. You could do something like this.

use oldtable in 0
use newtable in 0
select oldtable
scan
select newtable
append blank
replace fieldname with trim(oldtable.firstname)+' '+trim(oldtable.lastname)+' '+trim(oldtable.phone)
endscan

hope this get you started..
>
>
>Does anyone have any suggestions as how I can do this.
>
>
>Thanks,
>Todd