How to split particular row or column &add to another table?

Question

*   I have a data tables in data set.There are three tables in data set.In this data tables have 40 rows and fifty columns.

 

*   Now i want to split first row data means.in first row (all rows have 50 columns) split 1-st column to 20th column in first row.and stored another table.

 

*    And split 7 th column from from table and stored to another table.

 

*   All three table want to split in this method.

 

*   How to do?

 

is this possible..........................