Help ple!
I have tb1 in an access db and I want to transpose the data in tb1 to tb2 so that some of the data in tb1 becomes fields in tb2 and
some fields in tb1 become data in tb2. Both tables are in the same access db. I would appreciate any help.Tks u anyway.

You can create a make table query and map the required fields data to the new table.

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.

I have posted a new "help ple" where the problem is better explained. So please any help should be on the new posting.Tks.