transpose table in MS Access

[htammelleo]

I have a table that I have created to represent monthly buckets for specific date formats, like this:

Month1 Month 2 Month3 ...
201112 201201 201202

I have completed the make table query to determine what the starting month and subsequent months should be, but I need to be oriented the other way:

Month1 201112
Month2 201201
Month3 201202
...

What is the best way to accomplish this?