Select distinct values one column into multiple columns

[linvall]

I have a table with work orders (col 1) and a bunch hold codes (col 2), like in Ex1. Certain work orders can have multiple hold codes and will be repeated in col 1. Is there a way to make all the unique hold codes appear in the same column separated by a comma (Ex2) or in the same row but different columns (Ex3)? Thanks

[June7]

Example numbers in your narrative don't correspond with the images but I understand regardless.

Ex2 would be a CROSSTAB query. A CROSSTAB requires 3 fields minimum. So will have to calculate 3rd field. This will be a sequence number for each order group that will become the column headers. Need a unique record identifier - autonumber field should serve.

TRANSFORM First(Table1.Col2) AS FirstOfCol2
SELECT Table1.Col1
FROM Table1
GROUP BY Table1.Col1
PIVOT DCount("*","Table1","Col1=" & [Col1] & " AND ID<" & [ID])+1;

Ex3 would use VBA http://allenbrowne.com/func-concat.html

[linvall]

Thanks for this, I will take a look at this over the weekend.