To add to Alex' comment, if you have a memo as one of the fields, you would use:
Select table1
scatter memvar memo
>Dear Experts
>
>I have two tables, table1 and table2
>
>How to scatter table1?
>and then how to gather into table2?
>
>For example
>
>Select table1
>scatter
>select table2
>gather
>
>
>I do not want to use this command
>select table2
>append from table1
>
>Please help