how to distribute different values of one column in the new column fields

[masoud_sedighy]

In my table for duplicate "line no" I have different "contractor" like below.

LINE NO CONTRACTOR

L-0001 C-1000
L-0001 C-2000
L-0003 C-6000
L-0003 C-8000
L-0003 C-9000
L-0004 C-5000


Now I would like to make a query for transposing values like below:


LINE NO CONTRACTOR1 CONTRACTOR2 CONTRACTOR3

L-0001 C-1000 C-2000
L-0003 C-6000 C-8000 C-9000
L-0004 C-5000

Please help how I have to make this query?

 

[pr2-eugin]

I think the Query you are looking for is CrossTab. Check it out. If you only want to have the contractor to the lines, then you can use ConcatRelated.