column 2 to transpose using column 1 as reference

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike Fong - 31 Aug 2007 20:56 GMT

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

Reply to this Message

Pieter Wijnen - 31 Aug 2007 21:10 GMT

crosstab query wizard

Pieter

> Hello... please help with solution.
>
[quoted text clipped - 5 lines]
> 1004 1005
> 1004 1006

Reply to this Message

Mike Fong - 31 Aug 2007 22:10 GMT

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

> crosstab query wizard
>
[quoted text clipped - 9 lines]
> > 1004 1005
> > 1004 1006

Reply to this Message

KARL DEWEY - 31 Aug 2007 22:46 GMT

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;

Signature

KARL DEWEY
Build a little - Test a little

> Thanks for the reply, I looked at the crosstab query, but the
> wizard need atleast 3 fields. I only have two columns.
[quoted text clipped - 13 lines]
> > > 1004 1005
> > > 1004 1006

Reply to this Message