How to generate one long column from a series of rows?

Hi,

I am trying to reaccustom myself to Excel, after not having used it for a couple of years. So bear over with me if this is a silly question.

I have a set of data (or several actually) where each row is a year and each column is a month. I.e., I have monthly data for a variable in a 20x12 format when there is 20 years. I want to plot these as one continuous line (a line graph).

One way of doing this is of course to copy each line, paste them into one long line, and then copy and paste the transpose of this. But this gets cumbersome.

Is there an easier way?

I tried recording a macro, but couldn't figure out how to make the script general (I am a fairly adept programmer, but haven't gotten a hold of VBA yet. Not sure if it's worth it.).

I hope somebody can help.

Thanks a million!