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 && please correct this line
select table2
gather && please also correct this line

I do not want to use this command
select table2
append from table1

Please help