Use the TRANSPOSE function. Let's say your table is in Sheet1!$C$23:$N$38.
That's 16 rows by 12 columns.

On the 2nd sheet, select an area that's 12 rows by 16 columns. In the upper
left cell of the selection, type the formula =TRANSPOSE(Sheet1!$C$23:$N$38)
and press CTRL+SHIFT+ENTER.

BTW, you'll have to redo the formula if the size of the range changes (you add
or delete rows or columns).


On Wed, 26 Jan 2005 10:19:04 -0800, Ferrin444
wrote:

I'm trying to get a table "transposed" by referencing the cells in another
worksheet. Currently it looks something like this

January February March April
M1
M2
M3
M4

I'd like it to look like this, while maintaining a dynamic link:

M1 M2 M3 M4 M5
January
February
March
April

I'd like to be able to reference the first cell and then drag the formula
either down (instead of rows incrementing, the columns would increment) and
the same for dragging the formula to the right. Is this possible????

ie
D1 D2 D3 D4
E1 E2 E3 E4
F1 F2 F3 F4

where D1 was the first reference brought in and the rest were dragged and
filled from there.

Can anyone help???