column 2 to transpose using column 1 as reference

[Mike Fong]

Hello... please help with solution.

col1 col2 col1 col2 col3 col4
1001 1001 to 1001 1001 1002 1003
1001 1002 1004 1004 1005 1006
1001 1003
1004 1004
1004 1005
1004 1006

 

[Pieter Wijnen]

crosstab query wizard

Pieter

 

[Mike Fong]

Thanks for the reply, I looked at the crosstab query, but the
wizard need atleast 3 fields. I only have two columns.
Any other ideas?? Thanks in advance

 

[KARL DEWEY]

You can do it with two fields but I did not get your column labels as you
wanted.

TRANSFORM First(Mike_Fong.Col2) AS FirstOfCol2
SELECT Mike_Fong.Col1
FROM Mike_Fong
GROUP BY Mike_Fong.Col1
PIVOT Mike_Fong.Col2;