Crosstab Query with only 2 columns

[Guest]

I know how to crosstab a query, however my problem is that my query has only
2 colums and crorosstab require at least 3 columns.

This is what I have:

Col1 Col2
a 21
b 12
c 30

I would like to use the data in Col1 column ad header as follow:

a b c
21 12 30

How can be done? (FYI in reality col1 and col2 are numeric in my query)

Thank you,
Silvio

 

[Guest]

Create a select query to feed your crosstab. Include another field like this