To jemacc thank for the attention.
Let me explain the problem in detail so u can see if the solution is to make table qry and map the required fields to the new table.
Tb1 has FieldO with records 1,2,3,4,...and I want tb2 with Column0 = record 1 from Field0, Column1 = record 2 from Field0, Column3 = record 3 ...,and so on.
The records in tb2 Column0 = record 1 will come from tb1 Field1 as first row for example, tb1 Field2 as second row, tb1 Field3 as third row,..., and so on.
As a matter of fact tb1 in my case is a qry, but to make it simple think of it as a table. Tks u anyway sincerely for your support.