[Cambium]

Is there a way to do this without copying and pasting every column into one row?

My goal is to get a continuous line chart that shows 63 years worth of monthly data.

Using Excel 2010.

Thanks all.

[draceplace]

Some ideas....
You can select a column and do a copy/paste special and pick 'transpose' and it will flatten the vertical row. It will not work if you select the whole column. You have to select the populated fields in the column.

vbscript / macro to read down each column of sheet1 and write to row1 in sheet2 would be ideal. Not sure how many columns you can have in Excel?

I would think there would be a way to auto file a link going across. =Sheet1!A1, Sheet!A2...Sheet!A12, Sheet!B1...