Transpose Function

[wutzke]

I have a set of data
A1 Sat., Dec. 30, 2006
A2 Daily Temp
A3 12-17-20-41-47-49
A4 12
A5 49
A6 Sun., Dec. 31, 2006
A7 Daily Temp
A8 11-15-21-40-45-50
A9 11
A10 50

I name this Sheet "2006"
Using the Transpose Function I set up
=TRANSPOSE('2006'!A2:A5)
On another sheet called "Results" in cell B2

How can I repeat this in B3 for data in Sheet 2006 A6 thru A10?
This data continues to repeat in the same sequence (every 5 rows)

 

[wutzke]

Great function
But it didn't seem to work. I got the logic of it.

would it be better to use
=ADDRESS((((ROW()-2)*5)+1),1,1,,"2006")

and try to get the value another way?

 

[wutzke]

by the way the tranpose function should be
=TRANSPOSE('2006'!A1:A5)
and then
=TRANSPOSE('2006'!A6:A10)

too bad
=TRANSPOSE(ADDRESS((((ROW()-2)*5)+1),1,1,,"2006"):ADDRESS((((ROW()-2)*5)+5),1))
won't work

But I'd happy just getting the text for A3 & A8 into sequential rows
on another sheet

 

[Tom Ogilvy]

Transpose in a single cell doesn't make much sense. Normally you would do a
multicell array formula.

anyway, put this in B2

=OFFSET(Sheet1!$A$1,(ROW()-2)*5+COLUMN()-2,0,1,1)

then drag fill over to column F

then select B2:F2 and drag fill down