Select by value from the table and create two new tables

Hello! I have a table with “text” and “test” values in column 1 and “1”, “2”, “3” and so on in column 2. How can I select the “Text” values and its values from the second column from the first tables and add to new table1. Do the same with the “Test” values and its values from column 2 and put all this in table2?

hello @Wizzy_Ego

do you want to create one table for Each row ?

if that is the case simply loop through the table rows and add it to a new table.

if not please explain bit more