Move Data from Column to Row

[Guest]

I have a table that contains data in 2 columns. Column 1 = Part Name Column 2
= APL number. I want to create another table that has mulitple columns for
the APL number going across in a row format.
Ex.
Before
Pt Name APL
Screw 1234
Screw 4567
Screw 7890

After
Screw 1234 4567 7890

 

[Pat Hartman \(MVP\)]

Try using a crosstab query.

 

[Guest]

I don't understand.
I guess I should have said that I have 5 additional columns in this table.
When I tried a crosstab qry I did not get what I was looking for. It made
column heading names for every APL in the table and placed the next field
(Cage #) under the APL.
I want the column names to read Part No, APL1, APL 2...etc