Sqlite table creation

Is it possible to create tables based on a columns data? I currently have a table named Exchange which contains numerous columns

ID:NAME:PRICE
1:Stick:12
2:Stone:20
3:Water:1
4:Water:1

But I want to create numerous tables based on the Name column and select the rows that contain that name and move them to their respective table. So in the above example, the result would be 3 new tables Stick, Stone & Water The table Water would be

1:Water:1
2:Water:1