How to "Transpose"

[bkf7911]

I have data in the following format:

Month Q1 Q2 Q3 Q4 Q5 Q6
Jan 20 21 22 23 24 25

and need it in the following format (table or query, not form/report):

Month Question Volume
Jan Q1 20
Jan Q2 21
Jan Q3 22
Jan Q4 23
Jan Q5 24
Jan Q6 25

Is there a way to "transpose", much like in excel? I've used a series of update queries in the past, but this was cumbersome.

 

[SkipVought]

Transpose in excel and IMPORT.

Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}

 

[Remou]

How about:

SELECT Month, "Q1" As QNo, Q1 As Ans FROM ...
UNION
SELECT Month, "Q2" As QNo, Q2 As Ans FROM ...
<...>
UNION
SELECT Month, "Qn" As QNo, Qn As Ans FROM ...

 

[bkf7911]

Skip, I don't think that will work for my customer. Thanks for the offer though.

Remou, this so works. Thank you for saving me much time in writing and rewriting queries.