Trouble With Generating a Chart

[Stang70Fastback]

Hello all! Here is my latest conundrum:

I have a table of data that exists as such:

DISCIPLINE | MONTH1 | MONTH2 | MONTH3 | MONTH 4 | ... | MONTH 12
Architecture | 384 | 382 | 234 | 429 | ... | 434
Civil | 324 | 598 | 843 | 472 | ... | 425
Structural | 432 | 892 | 842 | 133 | ... | 743
etc...

What I want to do is generate a line graph for a 12 month period, where there would be one line for each discipline. However, when I use the chart wizard, it only allows me to select up to 6 fields. How can I restructure my information to work properly? Apparently I can't just select all 13 columns of information.

I have a hunch that I need to generate a table with the following structure, but I'm not sure how to transpose the data:

DISCIPLINE | MONTH | HOURS
Architecture | MONTH1 | 382
Architecture | MONTH2 | 234
...
Civil | MONTH1 | 324
Civil | MONTH2 | 598
...
Structural | MONTH1| 432
Structural | MONTH2 | 892
...
etc...

EDIT: Once again, after over an hour of searching, I finally find the solution 5 minutes after I post a question here. Got my answer from the following URL:

http://stackoverflow.com/questions/10210512/transpose-a-table-using-query-in-access