Query with two columns to Rows

[MrDummy]

Hello,



I have a query that results in the attached picture (Capture 1). What I want to do next is to transform the rows for which the Container number is the same to one row with all the records in the next columns

I have tried cross query but then it needs 3 Columns.

I have put the Start in Capture 1 and the desired result in Capture 2, Queryname is qryLabel.

Any help would be appreciated.

[pbaldy]

If you can live with them in one field:

http://allenbrowne.com/func-concat.html

[MrDummy]

Yes this is something I can start from. Many thanks.

[pbaldy]

No problem. Post back if you get stuck.