The TRANSPOSE function. But note that 1000 rows will become 1000 columns.
I am using excel 2002 SP3.
basically I have a sheet that has my data going down in column C by month c1 = jan values, c2 = feb values, etc.
In another worksheet, I need to reference those cells, but going across. in other words my 2nd worksheet will have in cell a1 = sheet1!c1, b1= sheet1!c2, etc...
because I have about 1000 rows of data, is there any easy way to do this using copy paste special formulas (with transpose) ?
t i a