Column as Row in a report

[MrDummy]

Good day,



I have a report based on a query. This query nicely make two columns. One with Number and other with Result. The Number can be the same in multiple rows with a different result (see below). Is it possible to transfer the result column to a row for each unique number. Or should this be done in a query. Next qustion is then: How can I do that in a query.

Query:
Number Result
1 4
1 5
1 2
2 5
2 9

My wish:

Number Result1 Result2 Result3
1 4 5 2
2 5 9

Many thanks

[Bob Fitz]

Not sure about this but sounds as though you need to create a "crosstab" query

[orange]

You might also review this material from Allen Browne.

[MrDummy]

Many thanks for your advise, "CrossTab" it is.