Flip 2 data columns in Access. Col-1 = Col Headings. Col-2 = List

[Guest]

I have 2 columns of data with forty records each, in an Access Table. Column
1 contains numbers representing groups (Group 1 thru Group 10). Column 2
contains forty 3-character codes (each code is different). The number
indicates which group the code belongs to. A group may have multiple codes in
it.

Goal- use a query or other tool (not a report) to convert/flip the data. To
have the ten group numbers (1 thru 10) become a column heading. Then list
each code below in its corresponding group's column.

Convert this:
1 HSS
1 HVC
1 HUH
2 MVN
2 BFP
3 WHT
4 PGN
4 PLM

To this:
1 2 3 4
HSS MVN WHT PGN
HVC BFP PLM
HUH

 

[Guest]

Use a crosstab query.